Hi,

I have a procedure which needs the date passed to it as an IN parameter.

when I run it manually it works fine
e.g exec test ('02-SEP-2002')
How can I automate this in order to get the IN parameter for yesterdays date, generated automatically.

Thanks in advance.