Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01858: a non-numeric character was found

ORA-01858: a non-numeric character was found

From: Martin, Alan (Contractor) (DLIS) <Alan.S.Martin_at_dla.mil>
Date: Mon, 23 Jun 2003 12:11:12 -0700
Message-ID: <F001.005B7E23.20030623114438@fatcity.com>

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 Received on Mon Jun 23 2003 - 14:11:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US