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

[Sorry if this post appears more than once. I ran into some trouble
with the Internet connection. Damn those corporate firewalls!]


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
Microsoft Windows 2000
Service Pack 2

x86 Family Model 8 Stepping 3
130.544 KB RAM

The Oracle server is 8i Enterprise Edition Release -

Now comes the strange part. When run the same application on a user
desktop of my client, then the procedure runs OK! No errors,

Desktop computer information:
Microsoft Windows NT

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

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!


Mon, 27 Dec 2004 04:12:17 GMT  
 Strange Oracle error: ORA-06502 (and Microsoft run-time error -2147467259(80004005))
Hi Marty,

Please refer to:
Q229757 FIX: Oracle OLEDB Provider Returns Err: "ORA06502: PL/SQL...";EN-US;Q229757

This error seems to be related with the database driver, so I suggest you
deploy the lastest MDAC, or the same as the desktop, to your laptop
computer from Make sure you are using the same ODBC
driver or OLEDB driver to access Oracle server.


This posting is provided "AS IS" with no warranties, and confers no rights.
"Got .Net?"

Sun, 02 Jan 2005 11:52:01 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Strange occurence of ORA-06502 error (and Microsoft -2147467259(80004005))

2. Strange error when calling procedure: ORA-06502 and -2147467259(80004005)

3. ORACLE ORA-06502 Error with RDO 2.0

4. Run-time error "-2147467259 (80004005) Automation error

5. Run-time Error -2147467259 (80004005)

6. Run-time error `-2147467259 (80004005)`: ...................when opening Word2000

7. Run-time Error -2147467259 (80004005)

8. Run-time error -2147467259 (80004005) when using adodc refresh method

9. run time error -2147467259

10. Run Time Error -2147467259(80004005)

11. Run-time error '-2147467259 (80004005)'

12. RUN-TIME ERROR -2147467259 (80004005)


Powered by phpBB® Forum Software