OraFAQ Forum: Client Tools » Debugging Procedure with Toad

Home » Other » Client Tools » Debugging Procedure with Toad

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

Debugging Procedure with Toad [message #186867]

Wed, 09 August 2006 23:53

ajitdsin
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

Rgds
Aj

Report message to a moderator

Re: Debugging Procedure with Toad [message #186899 is a reply to message #186867]

Thu, 10 August 2006 01:50

Littlefoot
Messages: 21824
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):

CURSOR c1 IS
SELECT * FROM emp
WHERE hiredate < TO_DATE('01.01.1990', 'dd.mm.yyyy');

and debug it.

Report message to a moderator

Previous Topic:	how to run a PL/SQL program in Toad
Next Topic:	Rounding off in SQL Navigator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 16 21:36:52 CDT 2025