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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06502: PL/SQL: numeric or value error: character to number

Re: ORA-06502: PL/SQL: numeric or value error: character to number

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Tue, 15 May 2001 23:28:28 +0200
Message-ID: <3B019F7C.6B7C49C2@0800-einwahl.de> 






The reason is a bug in 8.0.x that goes undetected.



If you do "nvl (' ', 55)" in 8.0.x it should give ORA-01722 because blanks are
*not* a valid number. However, the bug is that this does not raise an exception.
In 8.1.x this bug is fixed.



If you want the old buggy behaviour back you have to set event 10943. We had the
very same problem when upgrading from 8.0.5.2.1 to 8.1.6.3.0.



Martin
Received on Tue May 15 2001 - 16:28:28 CDT












Original text of this message













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