Re: escape colon char
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-lReceived on Thu Aug 18 2016 - 20:37:27 CEST