Home » SQL & PL/SQL » Client Tools » Debug procedure
Debug procedure [message #303449] Fri, 29 February 2008 06:51 Go to next message
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
Re: Debug procedure [message #303617 is a reply to message #303449] Sat, 01 March 2008 03:06 Go to previous messageGo to next message
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,
Re: Debug procedure [message #342907 is a reply to message #303449] Mon, 25 August 2008 08:25 Go to previous messageGo to next message
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
Re: Debug procedure [message #343290 is a reply to message #303449] Tue, 26 August 2008 18:35 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
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
Re: Debug procedure [message #351184 is a reply to message #343290] Mon, 29 September 2008 13:16 Go to previous messageGo to next message
vivekmcm
Messages: 4
Registered: January 2008
Junior Member

how To debug the procedure or function using SQL Navigator
Re: Debug procedure [message #351189 is a reply to message #351184] Mon, 29 September 2008 13:39 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
vivekmcm wrote on Mon, 29 September 2008 20:16
how To debug the procedure or function using SQL Navigator

Read the topic.

Regards
Michel

Previous Topic: where can i get TOAD free software
Next Topic: TOAD Review
Goto Forum:
  


Current Time: Thu Dec 08 00:12:18 CST 2016

Total time taken to generate the page: 0.19491 seconds