Re: Q: Stored procedures - result sets

Thomas,

Is the order of parameters important?
What about if I wish my SP to return more resultsets? How is it ensured that ODBC converts OUT parameter to resultset?

>
> See the URL in my .sig below and then the link "Getting Result Sets from
Stored
> Procedures (HOWTO)"
>

>
> 'CREATE OR REPLACE package reftest as
> ' cursor c1 is select ename from emp;
> ' type empCur is ref cursor return c1%ROWTYPE;
> ' Procedure GetEmpData(en in varchar2,EmpCursor in out empCur);
> 'END;
> '
> '
> 'CREATE OR REPLACE package body reftest as
> ' Procedure GetEmpData
> '(en in varchar2,EmpCursor in out empCur) is
> 'begin
> ' open EmpCursor for select ename from emp where ename LIKE en;
> 'end;
> 'end;
> '
>

--
Thank you for keeping >anti-spam< habit: not including my address in your reply. Received on Fri Aug 06 1999 - 03:16:02 CDT