Does this work?
time_text varchar2(100) := q'['begin
dbms_job.next_date(63,to_date('18/08/2016 12:10','dd/mm/yyyy hh24:mi'));
end; ']';
note the beginning q'[ and ending ]';
Chris
On Thu, Aug 18, 2016 at 11:33 AM, Ray Stell <stellr@xxxxxx> wrote:
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
