Re: Out Parameters/Ref Cursor/Ado 2.5

A couple of choices.
1. You can check for NULL data set in ADO 2. Return the Numrows in an OUT parameter and check for >0.

Keith Jamieson wrote:

> 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 - 21:28:07 CDT