Re: Q: Stored procedures - result sets

A copy of this was sent to "huh" <huhhy_at_rocfdasketmail.com> (if that email address didn't require changing) On Fri, 6 Aug 1999 10:16:02 +0200, you wrote:

>Thomas,
>
>
>Is the order of parameters important?

nope.

>What about if I wish my SP to return more resultsets?

use a procedure

create or replace procedure get_lots_of_stuff( c1 in out empCur, c2 in out empCur, c3 in out empCur )

>How is it ensured that ODBC converts OUT parameter to resultset?

don't know. don't do odbc. If you get that page again (Getting result sets...) there is an email address of the guy who contributed the ODBC example.

>
>>
>> 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;
>> '
>>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Aug 06 1999 - 08:22:44 CDT