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'
Apparently the procedure runs fine from TOAD.
Please let us know possible reasons for this behavior and also the solution to this problem