I pasted the runtime error "2147467259(80004005)" into Google
(http://www.google.com/advanced_search) and got 587 hits ... everything
from graphics intensive screens to moving between mailbox folders and
lots more. You might also do the same. Who knows, you might get lucky
and find your answer there ... or you might be overwhelmed with too much
info. Probably a lot of stuff that doesn't apply, but worth a look. :)
N3Gro wrote:
> 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 - 18:16:55 CDT