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