Hi Bill I have written your procedure as below. How to execute it
from SQL> prompt. I am geting problem when I say SQL> exec
demo_ref(2).
ERROR at line 1:
ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to
'DEMO_REF'
ORA-06550: line 1, column 7:
PL/SQL: Sta
You don't say what version you're using, but you could look at reference
cursors. Search Oracle docs (tahiti.oracle.com) for "REFCURSOR".
HTH! GL! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
---
Could not find any specific examples of this usage . . .
1) must it be inside a package? could it just be defined in a
procedure?
2) why IN/OUT? What's being passed in?
3) why open with no fetch? what does that accomplish?
thanks much
bill
-Original Message-
Sent: Tue,
Oracle9i supports this directly - look for pipelined PL/SQL functions.
Thanks, Bjørn.
On Tuesday 19 March 2002 14:58, Magaliff, Bill wrote:
> Hi,
>
> Is there a way to write a procedure to return multiple rows? I have some
> nasty SQL that I'd like to convert to run server-side, but how do you
FOR SELECT * FROM sal;
END IF;
END demo_ref;
>From: "Igor Neyman" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: what pl/sql construct can return multiple rows?
>Date: Tue,
Use Ref Cursor (reference cursor) as a parameter in stored procedure.
Sorry, don't have handy sample code, but you can lookup one in any PL/SQL
book or docs.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent:
This may help you :
http://www.oracle.com/oramag/webcolumns/2001/index.html?diy_dynamic.html
That said, sending horrors to the server is not solving the problem, just fudging it,
and bringing the server to its knees will not make the global througput better. I'd
try to make the SQL less nasty f
Bill,
A PL/SQL Table of %RowType can be returned from a function or as an
Out Argument from a procedure.
A Ref Cursor (Cursor Variable) can also be returned as an Out Argument from
a procedure.
See the PL/SQL Users Guide and Reference for info. on these.
Jack