Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange Oracle error: ORA-06502 (and Microsoft run-time error -2147467259(80004005))

Re: Strange Oracle error: ORA-06502 (and Microsoft run-time error -2147467259(80004005))

From: N3Gro <>
Date: Thu, 18 Jul 2002 18:51:39 -0400
Message-ID: <3d3747e9$1@omega>

sometimes , sometimes don't , the last time that it happened to me was with a cursor .and detect the problem was very hard... a great website with all the descriptions of SQLLDR, ORA ,AND PLS erros is

"Jesper Wolf Jespersen" <> escribió en el mensaje news:3d372857$0$16781$ Have you checked that the numeric format used by the oracle session and that used by your Visual Basic engine match ?

ORA-06502 is very commonly seen when text values are entered for numbers and the client enters a ',' where the server expected a '.' or vice versa.

Greetings from Denmark
Jesper Wolf Jespersen

"Marty Will Follow" <> wrote in message
> [Sorry if this post appears more than once. I ran into some trouble
> with the Internet connection. Damn those corporate firewalls!]
> Hello,
> I encounter a strange error when I try to call a stored procedure from
> a Visual Basic application. After calling the procedure I get the
> following error:
> Run-time error '-2147467259(80004005)':
> [Oracle][ODBC][Ora]ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at "SUSHI.SUSHI_HI_NI", line 153
> ORA-06512: at line 1
> Now, AFAIK, the run-time error is a Microsoft (VB) error while the
> second is an Oracle error, correct?
> I get this error when I use my laptop
> System:
> Microsoft Windows 2000
> 5.00.2195
> Service Pack 2
> Computer:
> x86 Family Model 8 Stepping 3
> 130.544 KB RAM
> The Oracle server is 8i Enterprise Edition Release -
> Production
> Now comes the strange part. When run the same application on a user
> desktop of my client, then the procedure runs OK! No errors,
> whatsoever.
> Desktop computer information:
> System:
> Microsoft Windows NT
> 4.00.1381
> IE
> Computer:
> x86 Family 6 Model 8 Stepping 3
> 260.404 KB RAM
> I've tried all I could localising the error, but I cannot find
> anything. The ORA-06502 would suggest that a variable in the procedure
> is not big enough for a certain value, but that does not explain why
> it works on other computers. Besides, AFAIK, the variables are big
> enough to hold the information (each defined variable has room for 100
> characters).
> Oh, and as a final touch to the mystery, when I directly call the
> procedure in SQL Plus from my laptop (and enter the same values as I
> do when I use the VB application) the procedure again works. I really
> don't know what's happening here!
> I hope the information presented here is clear enough. I personally
> have a lot of difficulty to get any grip on the situation. Hopefully
> you can help me out.
> C ya!
> Marty
Received on Thu Jul 18 2002 - 17:51:39 CDT

Original text of this message