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

[Igor Neyman]

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

There shouldn’t be quotes around TRANC(). This should work:   SQL> declare   2  stat boolean := false;   3  begin   4  DBMS_JOB.BROKEN(1,stat,TRUNC(SYSDATE)+22/24);   5  end;   6  /   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----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   The following was issued from SQL*Plus (8.1.7) on HP-UX 11.0: 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 I can replace "stat" with FALSE in the parameter list with the same results. What am I doing wrong? Thanx, Alan Martin Hart-Dole-Inouye Federal Center Battle Creek, MI