This content has been marked as final. Show 2 replies
Problem is the argument value expression is only evaluated at creation time. Years ago I filed an enhancement request to allow for parameter functions to make the use of parameters more dynamic. You could work around this with a wrapper that calls the stored procedure with the sysdate as an argument, instead of the scheduler calling your stored procedure directly.1 person found this helpful
Thanks Ronald for your valuable suggestions, is it possible to give some example here.