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