Passing variable in a macro

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: