Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pipelined table and Ref Cursor
harry.ramp_at_hotmail.co.uk wrote:
> Hi,
>
> I've got a c# .net application calling an Oracle package via ODP.NET.
>
> The package itself calls another vendor supplied function that returns
> a pipelined table based on an input parameter.
>
> I need to return the rows from this pipelined table to the .Net app.
> Currently a data reader is (trying) to do this.
>
> When I try to run the stored procedure I get the following error ...
>
> ORA-00600: internal error code, arguments: [qks3tAssert:1], [35072],
> [], [], [], [], [], []
> ORA-06512: at "VENDORSCHEMA.VENDORPACKAGE", line 1598
> ORA-06512: at "VENDORSCHEMA.VENDORPACKAGE", line 1636
>
> The procedure I'm trying to run is as follows ...
>
> 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;
>
> Is there a way to get this running? Or do I have to find another method
> of returning table data to .Net?
ORA-00600 = http://metalink.oracle.com
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Apr 19 2006 - 11:06:42 CDT