We help IT Professionals succeed at work.

debugging oracle store proc

royjayd
royjayd asked
on
730 Views
Last Modified: 2012-03-04
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
Comment
Watch Question

Sr Software Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
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

Author

Commented:
>>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

Author

Commented:
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.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
David VanZandtSr Software Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.