-
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|