0 Replies Latest reply on Jul 15, 2002 7:35 PM by 307993

    OraOLEDB error '80004005'  Unspecified Error

      We have a web-based application which uses ASP on IIS 5.0, Windows 2000, Oracle 9i. We are using the following connection string:

      "Provider=OraOLEDB.Oracle;Data Source=xxxxx; User Id=xxxx; Password=xxx;"

      All the ASP pages which have direct SQL statements written in them work fine, however pages where we are calling a PL/SQL stored procedure (we are not using reference cursors !!) causes the following error:

      OraOLEDB error '80004005'
      Unspecified error

      Apparently the procedure runs fine from TOAD.

      Please let us know possible reasons for this behavior and also the solution to this problem