Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Installing the SQLDebug database objects (Read 3208 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Installing the SQLDebug database objects
11.08.08 at 09:40:06
Installing the SQLDebug database objects
SQL*Debug is a debugging software program that allows the debugging of Oracle PL/SQL. It is especially helpful in debugging packages, functions, triggers and other stored objects.
With a dbms_otuput.put_line like syntax you can print debug message using the package call sqldebug.debug just giving as a parameter the message you would like to capture. Instead of dbms_output the output is not sent to the screen but to a windows program instead. The SQL*Debug program can tune into a particular session and will display the messages that will be generated from that session only.
To install the SQL*Debug database objects the install.sql script is provided. To install this script I suggest you use SQL*Plus on the database server. It is best to use a central schema. If you have no central schema you can use sys or system. I have used sys below.

Z:\>sqlplus sys/passwd@ora10g as sysdba
SQL*Plus: Release - Production on Mon Aug 11 09:36:08 2008
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP and Data Mining options
Back to top
« Last Edit: 11.08.08 at 13:28:26 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1