Re: Returning Recordset with Oracle SP

In article <8tk40q$k1t$1_at_nnrp1.deja.com>,   beeckm_at_my-deja.com wrote:
> Hi there,
>
> I am having a problem in some stored procedures
> that return recordsets to ADO (Visual Basic).
>
> I put all my SPs in one package and use a REF
> CURSOR as an argument to return the recordset.
> Thus, a Stored procedure requiring 3 args
> actually has 4: the ref cursor, but you don't
> have to bind it so OK I pass 3 params, and my SP
> returns a RS.
>
> I have a problem when my SP does NOT require args
> and the only arg is the REF CURSOR itself, the
> ADO Commandtext looks like
>
> {call SP_LIS_APPGROUPACCESS }

Is the problem as simple as the need to add parenthesis? {call SP_LIS_APPGROUPACCESS() }

If not, can you explain the error(s) you're getting?

>
> ald the SP in the package looks like:
>
> Procedure SP_LIS_APPGROUPACCESS(pRS OUT
> pRecordSet)
> IS
> BEGIN
> OPEN pRS for SELECT
> GAUSRGRP,GATAGXXX,GAFLVIEW,GAFLUPDT,GAFLCREA,GAFLD
> ELE,GAFLACC1,GAFLACC2,GAFLACC3,GAUSUPDT,GADTUPDT,G
> ATMUPDT
> From APPGRACC;
> end SP_LIS_APPGROUPACCESS;
>
> And the package header looks like:
>
> PACKAGE "RS" AS
> TYPE pRecordSet is REF CURSOR;
> Procedure SP_LIS_APPGROUPACCESS(pRS OUT
> RecordSet);
> END RS;
>
> Does anyone have an idea how I can get this to
> work?

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.