Link to home
Start Free TrialLog in
Avatar of Jay Roy
Jay RoyFlag for United States of America

asked on

debugging oracle store proc

hi guys

Is there a way to debug the store procedures? I am using Oracle SQL DEveloper with oracle version 11g. The store procedure is long and i want to check values step by step.
Any good tools/debuggers ?
Willing to pay if the tool is really good.

thanks
ASKER CERTIFIED SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jay Roy

ASKER

I already have SQL Developer in my system but i am not sure how to debug the proc.
I click on Debug but i am not able to put break points on the cursor.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Adding to tosse, when a procedure is compiled, choose the DEBUG option.  Googling for "how to debug pl sql code in sql developer", try something like http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/plsql_debug_OBE/plsql_debug_otn.htm
Avatar of Jay Roy

ASKER

>>By right clicking in this marging you can set breakpoints, then use the Run menu to step into/over etc. as usual when debugging.


thanks , i can also do right click-->toggle break point to set the breakpoint.
However when i click Run--> TRADE_PROC_BODY   (which is my procedure body)

I see 'Source does not have a runnable target.'  message on myconsole

any idea?

thanks
Avatar of Jay Roy

ASKER

just to make it more clear this is what i have

i have created a package. My package body is called 'TRADE_PROC' body
In 'TRADE_PROC' body  i have

....
...
CURSOR tr_task IS   -- i put a break point here  
SELECT task_id from task_table;
 
 BEGIN
 OPEN  tr_task;   --put a break point here  
 FETCH tr_task BULK COLLECT INTO task_def_id;

but when  i click Run or Debug option i see
Source does not have a runnable target.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial