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

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 p...