error in stored procedure.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: error in stored procedure.

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    29

    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.

  2. #2
    Join Date
    Jan 2008
    Posts
    2
    I am running into the same issue. Did you find a solution to this? why is it happenning?

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  4. #4
    Join Date
    Jan 2008
    Posts
    2
    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

  5. #5
    Join Date
    Feb 2008
    Posts
    1
    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
  •  


Click Here to Expand Forum to Full Width