Re: StoredProcedures & recordsets

There is no record set in Oracle like there is in MSSQL. One solution is to write the procedure so it does the processing within a cursor loop. Another alternative is to pass back the selected values in a PL/SQL table (array). To do the later, you need to define a in/out parameter in your procedure and put your selected values into the array.

-Mike

Stu wrote in message <37989383.E4D8B4F6_at_dkmsoft.com>...
>I am new to Oracle, but all I am wishing to do is convert some stored
>procedures from MSSQL6.5.
>However, I have hit a problem straight away, I do not seem to be able to
>get the procedures to behave in the same way.
>The MSSQL procedures are being called from VC++ and the results are held
>in a recordset, but with oracle I cannot see how to
>get them to behave in this way. For example a procedure in MSSQL may
>say:
>
>CREATE PROCEDURE sp_GetEmp @empid int
>as
> select * from employess where employerId=@empid
>return
>
>
>and this would return a recordset which I can iterate through if more
>than one value.
>
>
>
>Is it possible to do the same thing with Oracle (8) to acheive the same
>effect.
>
Received on Fri Jul 23 1999 - 12:39:59 CDT