My intent is to create an archive file using the system date formatted as YYYYMMDD.
here is my macro code:
I tried adding “from dual” but it didn’t work with that either.
here is the error I am getting:
The log shows exactly what I need to happen…
The issue was how I was calling the macro. I need to call 2 macros post_hook.
Here is what worked perfectly:
