How to Pass Timestamp from Apex to PL/SQL trigger code
Hi,
I have a variable on Apex 'P25_TIMESTAMP' and I would like to pass it to a PL/SQL trigger code because I would like to store the timestamp in my column.
1) I modifed the 'P25_TIMESTAMP' as the systimestamp in the computation area of Apex using to_char
to_char(p25_timestamp)
2) In the PL/SQL code, when I tried to access the variable v(p25_timestamp) and convert it to a timestamp, it fails.
Update table
set timestampcolumn = to_timestamp(v(p25_timestamp); -- does not work
set timestampcolumn = cast(v(p25_timestamp to timestamp); -- does not work
set timestampcolumn = to_date(v(p25_timestamp ); -- works, yet it only stores the date portion, I would like the whole timestamp info in the last few digits.
Thanks.