Re: escape colon char

It looks to me like you need to escape the second, third, and fourth single quote (') characters. The way you have the text written, the :mi would be interpreted as a bind variable. So put two ' characters to escape them where they are part of the string:

time_text varchar2(100) := 'begin dbms_job.next_date(63,to_date(''18/08/2016 12:10'',''dd/mm/yyyy hh24:mi'')); end; ';

Andy

On Thu, Aug 18, 2016 at 11:33 AM, Ray Stell <stellr_at_vt.edu> 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!
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l