Home » SQL & PL/SQL » Client Tools » PL/SQL step by step Execution (Windows XP Professional Service Pack 2)
PL/SQL step by step Execution [message #586112] Mon, 03 June 2013 08:59 Go to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi,

Is there any option available in SQL developer to find the
step by step execution of the program - where the control goes
for better understanding.

If not available in SQL developer please suggest me the tool name
in which the option is available.

Thanks,
Ganesh
Re: PL/SQL step by step Execution [message #586113 is a reply to message #586112] Mon, 03 June 2013 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 22551
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/doc.112/e12152/intro.htm#sthref314
Re: PL/SQL step by step Execution [message #586115 is a reply to message #586112] Mon, 03 June 2013 10:40 Go to previous message
thatjeffsmith
Messages: 37
Registered: July 2009
Location: Raleigh, NC
Member

Your best option would be to invoke the debugger and step through the execution, line by line, to see it for yourself.

DBMS_PROFILER records lines executed and time spent per line, but you'll need to setup a run on your own as we currently only support the Hierarchical Profiler.
Previous Topic: PLS-00201: identifier 'Q$ERROR_MANAGER.REGISTER_ERROR' must be
Next Topic: create .MDD file
Goto Forum:
  


Current Time: Thu Jul 31 19:16:26 CDT 2014

Total time taken to generate the page: 0.08712 seconds