escape colon char
From: Ray Stell <stellr_at_vt.edu>
Date: Thu, 18 Aug 2016 12:33:33 -0400
Message-ID: <83bb0bc1-6929-96dd-570c-263bade919d1_at_vt.edu>
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?
Date: Thu, 18 Aug 2016 12:33:33 -0400
Message-ID: <83bb0bc1-6929-96dd-570c-263bade919d1_at_vt.edu>
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!
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 18 2016 - 18:33:33 CEST