Right click on it, and select Compile for Debug. CREATE OR REPLACE PROCEDURE testFirstNameįirst, go to the object explorer and find your procedure or function. I’ve created a procedure called TESTFIRSTNAME, which just runs a simple query and outputs the result to the console using DBMS_OUTPUT. You’ll need a code object for this, such as a function or procedure.
So, you’ll need to identify which code you want to debug.
Debugging normal SQL code is not possible, and wouldn’t make sense, as the entire statement is executed at once. You can only debug in code that has multiple steps. How Do You Start an SQL Developer Debug Session?įirst of all, you can only debug on PL/SQL code. Learn how to use the SQL Developer debug feature in this article. The debug feature of any IDE is an important and commonly used feature.
0 kommentar(er)
