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.