Jay Roy
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I click on Debug but i am not able to put break points on the cursor.