Re: <Q.> Stored Procedure?
Date: 1997/11/08
Message-ID: <3463c081.19542090_at_news.nothingbutnet.net>#1/1
Thanks but if you use a cursor to return a recordset set, how would you call it from say VB.
For example with MS SQL you would use { CALL Procedure_Name } but with Oracle do you have to use a return since you are using a cursor like { CALL ? = Procedure_Name }
No params going in.
Again thanks!! Oracle is different but I am getting the hang of it!
>You cannot use select in this way within a stored procedure. To
>acheive what you require you can either select INTO a variable (if
>your select returns one row) or use a cursor. If you use a cursor you
>then need open, fetch each row and close the cursor or use a cursor
>for loop.
>
>eg
>
>create or replace procedure x as
>
> cursor mycur is select * from table;
>
>begin
>
> for i in mycur
> loop
>
> -- do your processing here
>
> end loop;
>
>end;
>
>
Received on Sat Nov 08 1997 - 00:00:00 CET