Oracle SQL Declare a column and select today's date into the column

[yes1819]

Hi
I need to put today’s date in a column called “P_SNAP_DATE”
Oracle stored procedure
Execute Immediate ‘select sysdate from dual’ into P_SNAP_DATE
was working fine in the Oracle.
When I put that sql into Oracle-Execute snap, it gave me below error message.
Can anyone help me on this?
Thank you

[koryknick]

Very welcome. Glad it is what you need!