test template; sysdate parameter

[cosmini]

hi there;
I'm trying to debug a procedure that takes a date as parameter which needs to be the current sysdate (up to the second or millisecond). Is there a way to specify 'sysdate' as the value of the in parameter?

PL/SQL Dev. seems to be complaining about that.

thx,
Cosmin

 

[patch]

Try creating a local variable in the test script which you can assign sysdate to and then pass this into the procedure.
Or just remove the bind variable from the call and just pass sysdate as a parameter.

Hope this helps,
Patrick