Re: Pipelined table and Ref Cursor

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Wed, 19 Apr 2006 17:46:59 +0200
Message-ID: <e25m1l$upg$1@news1.zdv.uni-mainz.de>

harry.ramp_at_hotmail.co.uk schrieb:

> procedure GetObjects (id in number, lref_cursor out refCursor)
> is
> localCursor refCursor;
> begin
> OPEN localCursor FOR
> SELECT * from TABLE(vendorschema.vendorfunction(id));
> lref_cursor:=localCursor;
> end GetObjects;

Why do you use a procedure for this?
You can directly query the pipelined table function like a table.

> Is there a way to get this running? Or do I have to find another method
> of returning table data to .Net?

Just use the DataAdapter to make this query: "select * from table(vendorschema.vendorfunction(:1))". Then bind whatever id you want to look for as ":1" and there you are. No need for a ref cursor here, me thinks.

hth,

Moritz Received on Wed Apr 19 2006 - 10:46:59 CDT