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 -> Ora-06502

Ora-06502

From: LEE_HARRIS <lee_harris52_at_hotmail.com>
Date: Fri, 23 May 2003 17:36:24 +0000
Message-ID: <2916417.1053711384@dbforums.com>

I have a client using a intranet web site running on W2000 Server, ADO 2.6, IIS/5.0, Script Engine 2.1 - connecting to an oracle database 9.02, and performing updates. The client intermittently gets a PL/SQL error - invalid number or value:, in a previous answer to a similar error someone else had, someone stated that this could be due to a ',' being understood to be a '.' when the data is being sent to Oracle from a string i.e. '200,10' and oracle doesn't understand that the , should be treated as a decimal. Firstly, can this be the case. Secondly, how would I check this out - as the clients using the web server are from multinational locations which may be using the , as a decimal indicator. Thirdly, could ADO be breaking down somewhere when passing the data through to Oracle and simply sending incomplete update parameters i.e. NULLS where there shouldn't be. This is quite confusing as the problem is intermittent and restarting Oracle, i.e. releasing all the connections resolves the problem. This problem also surfaced about 9months ago when the database was 8.17. If the first question is yes, how do I go about telling Oracle that , are can also be decimals? I understand the general reasons for receiving this error, invalid field sizes, invalid conversion between strings and numerics, but this is very strange

Thanks in advance for any help

--
Posted via http://dbforums.com
Received on Fri May 23 2003 - 12:36:24 CDT

Original text of this message

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