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
Messages: 34
Registered: January 2011
Location: Thanjavur

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.

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
Messages: 24273
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

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
Messages: 57
Registered: July 2009
Location: Raleigh, NC

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: Sat Nov 28 20:21:54 CST 2015

Total time taken to generate the page: 0.12754 seconds