Re: how to pass a resultset out of a store procedure

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
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 Tue Feb 13 2001 - 22:22:09 CST