Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parameterized Queries?
sbradk_at_orcsweb.com wrote:
>
> I have created some functions and Stored Procedures in Oracle that return
> values, but I now have the need to return a recordset. Is this possible?
>
> It would basically be a compiled query that receives parameters then returns
> the results. Any help would be appreciated.
>
> TIA,
>
> -Brad Kingsley
> ORCS Web - http://www.ORCSWeb.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
You can return PL/SQL tables from procedures etc
create or replace package global is
type my_type is table of employees%rowtype;
end;
procedure xxx(v in out global.my_type);
function yyy return global.my_type;
etc
--