Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Set Up Breakpoints in Debug Mode
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped, you can then investigate different variables to see their current values. The tutorial below shows you how to set up breakpoints:
You should see the following in the Debugging Log area:
Connecting to the database Local_XE. Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '127.0.0.1', '3685' ) Debugger accepted connection from database on port 3685. Processing 59 classes that have already been prepared... Finished processing prepared classes. Source breakpoint occurred at line 3 of HELLO.pls. Source breakpoint occurred at line 4 of HELLO.pls. Hello world! Welcome to PL/SQL! Process exited. Disconnecting from the database Local_XE. Debugger disconnected from database.
2007-04-28, 7341👍, 0💬
Popular Posts:
What is the difference between Authentication and authorization? This can be a tricky question. Thes...
What is the version information in XML? “version” tag shows which version of XML is used.
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...
Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...
How To Add Column Headers to a Table? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells I...