try this -
declare stat boolean := 0
Shaibal Talukder Discover Financial Services Oracle Engineering [EMAIL PROTECTED] Work Phone :(224) 405 1140 Cell Phone :(513) 850 3721
From: "Martin, Alan (Contractor) (DLIS)" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list 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 / 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
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).