Query Database while Debugging the stored procedure

[Prashanth Deshmukh]

Hi,

I want to query the database while debugging the Stored procedure..

Here I cant use Dual Mode since only one window can be executed in Dual Mode..

Please let me know any alternate solutions..

I'm using PL/SQL Developer version 5.1.6.747

 

[DoDo]

I do it this way:
Try:
1. Make test tables for inserts or updates
2. Make views for selecting from test and real tebles
3. Make autonomous procedures, for inserting or updating paralel test tables, with commit in it
4. In tested procedures use those autonomous procedures after DML statements, on real tables, to insert or update test tables

In this way you can read test tables without commiting changes to real tables. Do not forget to clear changes in test tables before new test.

Or, if you just want logging messages, create message table and again make automomous procedure to insert into message table

Hope this helps.

 

[Prashanth Deshmukh]

Hi,

Since I work on UAT database,I cant create tables and test as and when required..

Please let me know if there are any other alternatives..

 

[ScottMattes]

I define cursor variables in the test window and do before and after queries that i can view AFTER execution is done.

Also, I do not commit changes in the code being tested nor in the test window - a click on the rollback button and the test is repeatable.