Re: escape colon char

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 18 Aug 2016 13:37:27 -0500
Message-ID: <CAP79kiSUFaoztZOdbHJy3O_9iN7MJPR08J52H9OYGUh4xiE_dQ_at_mail.gmail.com>



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_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
Received on Thu Aug 18 2016 - 20:37:27 CEST

Original text of this message