5/24/2023 0 Comments Sqlplus get sql prompt insert modeRight-click the PL/SQL object that you want to debug and select Database Tools | Recompile. The compilation helps the Oracle interpreter to process your code faster. The process of compilation converts PL/SQL code to Pro*C, which is then compiled to Oracle shared libraries. To enable debugging for a PL/SQL code, you need to compile it with the debug option. Compile a PL/SQL object with the debug option Right-click the Oracle data source and select Open Console Ctrl+Shift+F10.Ĭlick the Execute button or press Ctrl+Enter to run the procedure code.Īs a result, you see a created object in the Database tool window ( View | Tool Windows | Database).Ī code snippet of the procedure on GitHub Step 2. ![]() ![]() In Oracle, you can debug the following program units (PL/SQL programs): anonymous blocks, packages, procedures, functions, and triggers. The debugger is based on the Oracle Probe that uses API of the DBMS_DEBUG package and should work on Oracle servers 9.0 and later.
0 Comments
Leave a Reply. |