Out Parameters/Ref Cursor/Ado 2.5

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Tue, 3 Apr 2001 17:36:05 +0100
Message-ID: <9acu7h$5sq$1@kermit.esat.net>

I have a procedure which populates a ref cursor based on the memberid passed in. This works fine when called from VB/ADO 2.5 as long as the memberid exists.

The syntax of the call is below:

set rsRecordset = objCommand.Execute

If an invalid memberid is passed in, I don't populate the ref cursor. Instead, two out parameters are populated, one with the error message and one with the error text.

However, the ADO call to the procedure fails since the recordset does not exist. The Out Parameters are not populated either.

The error message is below:

ORA - 03113 End of File on Communication Channel.

The only workaround I can think of is to issue a select from dual where X=Y to generate an empty recordset. However, this would involve quite a significant amount of rework.

Has anyone come across this problem beforw, and If so, how did they resolve the situation.
NB: The procedure works as expected when called from sqlplus. Received on Tue Apr 03 2001 - 11:36:05 CDT