Re: ORA-01858: a non-numeric character was found

From: Shaibal Talukder <shaibal_talukder_at_hotmail.com>
Date: Mon, 23 Jun 2003 13:21:55 -0700
Message-ID: <F001.005B7F9D.20030623124511@fatcity.com>

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). Received on Mon Jun 23 2003 - 15:21:55 CDT