Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: return BOTH a recordset and an OUT par from Oracle Stored Proc using ASP and ADO

Re: return BOTH a recordset and an OUT par from Oracle Stored Proc using ASP and ADO

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 25 Aug 2004 17:17:13 +0200
Message-ID: <babpi0d8if351hf1o57cp2clvub8t4etrq@4ax.com>

On 25 Aug 2004 08:01:49 -0700, carlogol_at_virgilio.it (Carlo) wrote:

>I mean: the stored procedure compiled and worked if called by
>anonymous PL/SQL code. Nor I got any error from my asp page. Simply: I
>could loop thru the recordset, but I was not able to retrieve the
>value of this output parameter.
>
>Can you help me please?

Your procedure has 2 formal parameters. You call it using only 1 actual parameter. You need to modify the call to make sure it uses 2 parameters.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Aug 25 2004 - 10:17:13 CDT

This message: [ Message body ]
Next message: Frank van Bortel: "Re: how to handle updates to millions of rows"
Previous message: Hans Forbrich: "Re: Help: - dbstart on Oracle9i/redhat8"
In reply to: Carlo: "return BOTH a recordset and an OUT par from Oracle Stored Proc using ASP and ADO"
Next in thread: Carlo: "Re: return BOTH a recordset and an OUT par from Oracle Stored Proc using ASP and ADO"
Reply: Carlo: "Re: return BOTH a recordset and an OUT par from Oracle Stored Proc using ASP and ADO"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US