error in stored procedure.

we have upgraded Oracle 8.0.5 to Oracle 9.2.

Only when i am saving in a table i get the following error. i have used a stored Procedure at the backend and i am calling stored procedure from front end. The error is


DB Error Number -2147217900
Source : Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC driver for Oracle][Oracle] ORA-20003.

another error is

DB Error Number -2147217900
Source : Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC driver for Oracle]
Syntax error or access violation.

The retrieval is working perfectly fine.
only saving gives this error and only on this stored procedure.

Somebody please help me.

I am running into the same issue. Did you find a solution to this? why is it happenning?

Is your storedproc valid?
Does the user account has execute priv granted on the storedproc?
Can you execute the storedproc from sqlplus while sitting on the client box?

The problem is resolved.I had to add the username in front of the procedure name. This is not a new program and it was working without it. I changed something unrelated.

The user has execute priv. and there is synonym for the function, so it should work without the owner name when we call it. I think it is something to do with adodb.

Thanks for the reply,
Serpil

I had the same error:
Source : Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC driver for Oracle][Oracle] ORA-20003

when trying to run some ASP code that I had running earlier in the day.

I've recompiled the Oracle stored procedures that the routine calls and this has fixed my problem.