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, 7286👍, 0💬
Popular Posts:
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
Can we get a strongly typed resource class rather than using resource manager? In the previous quest...
How To Enter a New Row into a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Dev...
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...
How could Java classes direct program messages to the system console, but error messages, say to a f...