I want to change another users job run time with
sys.dbms_sys_sql.parse_as_user. When I set a timestamp var with hh24:mi
for a specific next_date run time the interpreter uses mi as a bind
var. How can I escape this timestamp?
time_text varchar2(100) := 'begin
dbms_job.next_date(63,to_date('18/08/2016 12:10','dd/mm/yyyy hh24:mi'));
end; ';
Calling sys.dbms_sys_sql.parse_as_user I get: SP2-0552: Bind variable
"MI" not declared.
That's all folks!
--
//www.freelists.org/webpage/oracle-l
