Title: 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
Title: ORA-01858: a non-numeric character was found
There shouldnt 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
) 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
ORACLE-L [EMAIL PROTECTED]
Subject: ORA-01858: a non-numeric character was found
Date: Mon, 23 Jun 2003 11:44:39 -0800
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