Re: how to pass a resultset out of a store procedure
From: M Hashim <mhashim_ca_at_passport.ca>
Date: Tue, 13 Feb 2001 23:22:09 -0500
Message-ID: <3A8A07F1.AA68541C_at_passport.ca>
Date: Tue, 13 Feb 2001 23:22:09 -0500
Message-ID: <3A8A07F1.AA68541C_at_passport.ca>
[Quoted] Put it in a package
TYPE OutParm??? IS REF CURSOR;
CREATE OR REPLACE PACKAGE BODY ReturningCursorDataSet AS TYPE OutParmCursorType IS REF CURSOR;
PROCEDURE ProcReturningCursorDataSet( o_CursorSet OUT OutParmCursorType)
AS
etc....
OR
[Quoted] return it from a function.....
Surti wrote:
> If i want to write a statement "select * from abc" (which returns multiple
> records with multiple fields) then how can i pass this resultset to me front
> end. the output parameters won't work here as I need to pass out multiple
> records
>
> Any help will be appreciated
Received on Wed Feb 14 2001 - 05:22:09 CET