Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
Received on Mon Jun 23 2003 - 14:11:12 CDT
![]() |
![]() |