Home » SQL & PL/SQL » Client Tools » Debugging Procedure with Toad
Debugging Procedure with Toad [message #186867] Wed, 09 August 2006 23:53 Go to next message
Messages: 1
Registered: August 2006
Junior Member
I have a procedure which i am trying to debug woth TOAD. The procedure doesnt take any input parameter, however, the cursor within the Procedure takens an input parameter of DATE. In toad whil we have to do Trace In option , i dont know how to pass the parameter. Also to test if i neeed to pass date value in a variable inan PL/SQl blok how do it do it?
is it like v_date DATE(8):= '20060810' or something else

Re: Debugging Procedure with Toad [message #186899 is a reply to message #186867] Thu, 10 August 2006 01:50 Go to previous message
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
For debugging purposes, it doesn't really matter how the cursor gets date value - is it a parameter or hard-coded value. Therefore, declare it without a parameter (something like this):

WHERE hiredate < TO_DATE('01.01.1990', 'dd.mm.yyyy');

and debug it.
Previous Topic: how to run a PL/SQL program in Toad
Next Topic: Rounding off in SQL Navigator
Goto Forum:

Current Time: Sat Oct 24 22:07:51 CDT 2020