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

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 http://tahiti.oracle.com
bye

"Jesper Wolf Jespersen" <oz8ace_at_qsl.net.spam> escribió en el mensaje news:3d372857$0$16781$edfadb0f_at_dspool01.news.tele.dk... 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" <marty_mj_at_my-deja.com> wrote in message news:8d15cc45.0207101212.3c6d4412_at_posting.google.com...
> [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
> AT/AT COMPATIBLE
> 130.544 KB RAM
>
> The Oracle server is 8i Enterprise Edition Release 8.1.7.0.0 -
> 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 5.5.50.4522.1800
>
> Computer:
> x86 Family 6 Model 8 Stepping 3
> AT/AT COMPATIBLE
> 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