โ10-27-2020 11:06 AM
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
โ10-27-2020 11:53 AM
Can you provide more context around what you are trying to do? Do you need to perform multiple statements in the execute and this is just the first one? Or do you need the current timestamp in the pipeline?
โ10-27-2020 11:55 AM
I want to do exact same thing that Oracle PL/SQL does.
In the Oracle, I created Stored Procedure, thatโs like below.
This will be the only statement in this snap
โ10-27-2020 11:58 AM
You can add an output view to the Execute snap and use the following in your SQL Statement:
select sysdate as โP_SNAP_DATEโ from dual
This will product an output field from the snap as โP_SNAP_DATEโ with the current timestamp.
Or, you could do the same thing in a Mapper snap and use Date.now() as the expression.
โ10-27-2020 12:00 PM
That worked! Thank you so much!