RE: ORA-01858: a non-numeric character was found

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>There shouldn&#8217;t be quotes around TRANC().

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>This should work:

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:

10.0pt'>SQL> declare
  2  stat boolean :=
false;
  3  begin
  4 
DBMS_JOB.BROKEN(1,stat,TRUNC(SYSDATE)+22/24);   5  end;
  6  /

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span

style='font-size:10.0pt;color:navy'>Igor Neyman, OCP DBA

<span

 style='font-size:10.0pt;color:navy'>[EMAIL PROTECTED]

<span

style='font-size:10.0pt;color:navy'> 

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martin, Alan (Contractor) (DLIS)
Sent: Monday, June 23, 2003 2:45
PM
To: Multiple recipients of list
ORACLE-L
Subject: ORA-01858: a non-numeric
character was found

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt'>The following was issued from SQL*Plus (8.1.7) on HP-UX 11.0:

<span

style='font-size:10.0pt'>SQL> declare
  2  stat boolean :=
false;
  3  begin
  4 
DBMS_JOB.BROKEN(1,stat,'TRUNC(SYSDATE)+22/24');   5  end;
  6  /
declare
*
ERROR at line 1:
ORA-01858: a non-numeric character
was found where a numeric was expected
ORA-06512: at line 4

<span

style='font-size:10.0pt'>I can replace "stat" with FALSE in the parameter list with the same results.
What am I doing wrong?

<span

style='font-size:10.0pt'>Thanx,
Alan Martin
Hart-Dole-Inouye Federal Center

Battle Creek, MI Received on Mon Jun 23 2003 - 14:45:07 CDT