| 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
|
|
|
|
| Re: Debugging Procedure with Toad [message #186899 is a reply to message #186867] |
Thu, 10 August 2006 01:50  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
