OraFAQ Forum: Client Tools » PL/SQL step by step Execution

Home » Other » Client Tools » PL/SQL step by step Execution (Windows XP Professional Service Pack 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL step by step Execution [message #586112]

Mon, 03 June 2013 08:59

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

Report message to a moderator

Re: PL/SQL step by step Execution [message #586113 is a reply to message #586112]

Mon, 03 June 2013 09:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/doc.112/e12152/intro.htm#sthref314

Report message to a moderator

Re: PL/SQL step by step Execution [message #586115 is a reply to message #586112]

Mon, 03 June 2013 10:40

thatjeffsmith
Messages: 81
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.

Report message to a moderator

Previous Topic:	PLS-00201: identifier 'Q$ERROR_MANAGER.REGISTER_ERROR' must be
Next Topic:	create .MDD file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 08 17:26:24 CDT 2026