OraFAQ Forum: Client Tools » Debug procedure

Home » SQL & PL/SQL » Client Tools » Debug procedure

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

Debug procedure [message #303449]

Fri, 29 February 2008 06:51

amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore

Junior Member

Hi

How to debug a procedure and function using SQL Navigator

Thanx & Regards

Amit

Report message to a moderator

Re: Debug procedure [message #303617 is a reply to message #303449]

Sat, 01 March 2008 03:06

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

Debugging the PL/SQL Procedure

http://www.oracle.com/technology/obe/sqldev/plsql_debug/plsql_debug.htm

regards,

Report message to a moderator

Re: Debug procedure [message #342907 is a reply to message #303449]

Mon, 25 August 2008 08:25

amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore

Junior Member

Thanx for Link.But this link show how to debug procedure using PL/SQL Develper.I want to How to debug procedure usni SQL Navigator.

Thanx

Amit

Report message to a moderator

Re: Debug procedure [message #343290 is a reply to message #303449]

Tue, 26 August 2008 18:35

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Some thoughts,

1) even though the link shows a different tool, the concepts you would be looking for (need for debug mode, stepping through lines, pausing execution with breakpoints), will all be the same. The difference would just be in the actual clicks for your specific tool so read it anyway.

2) instead of reading #1 maybe you should dig up the sqlnavigator manual. There has got to be a chapter on how to use its debugger. read that instead.

3) you might also wish to go old school. I presume you have sqlplus. debug in that using tried and true methods of commenting out code, and inserting message printing statements.

Good luck, Kevin

Report message to a moderator