error in stored procedure.

[varshanswamy]

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.

[serpilce]

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

[PAVB]

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?

[serpilce]

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

[obyapka]

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.