Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-06502 when moving from 8.0.5 to 8.1.7

ORA-06502 when moving from 8.0.5 to 8.1.7

From: NM <nimesh_myanger_at_hotmail.com>
Date: 17 Dec 2001 23:51:35 -0800
Message-ID: <bdae89b.0112172351.3f9f01a9@posting.google.com>


Hi,

I have a simple stored procedure that works in 8.0.5 but not in 8.1.7 - anyone have an idea why this does not work?

Code:

BUY_SELL (buy IN CHAR, sell IN CHAR )
RETURN CHAR IS BEGIN
   IF buy IS NOT NULL THEN

      RETURN buy;
   ELSE
      RETURN sell;
   END IF;
END buy_sell;

Any input will be greatly appreciated.

Thanks,
NM Received on Tue Dec 18 2001 - 01:51:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US