Stored procedure problem

Results 1 to 2 of 2

Thread: Stored procedure problem

  1. #1
    Join Date
    Dec 1969

    Default Stored procedure problem

    Hello,<BR><BR>I&#039;m having a strange with with Oracle stored procedure calling from ASP. If the stored procedure returns 12 columns then everything works fine. If it returns more than 12 columns then execution fails in ASP though it works fine when we run SP standalone. What could be the problem ? Any ideas. We are using Oracle 8i.<BR><BR>Error #-2147217900 Syntax error in {resultset...} ODBC Escape.<BR>Reported by: Microsoft OLE DB Provider for Oracle<BR>Help Context ID: 0Error #-2147217900 One or more errors occurred during processing of command.<BR><BR><BR>Thanks !

  2. #2
    Join Date
    Dec 1969

    Default First thing I'd try...

    is switch the ODBC driver to the one from Oracle and try it again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts