How to Update the Date in PL/SQL using a variable?
Hi,
I am setting up a varchar of an update statement and would like to put a date variable for the value. It works when I just put SYSDATE in the statement, yet doesn't when I put the date variable. Gives me an ORA-0904 error. Thanks.
DECLARE
v_upd VARCHAR2(32767); -- update statement
l_date varchar(20);
BEGIN
select sysdate into l_date from dual;
v_upd := 'UPDATE table_name SET LAST_MODIFIED_DATE = ' ||
l_date ;
v_upd := v_upd || ' where xyz =''123'' ';
EXECUTE IMMEDIATE v_upd;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END;