Solved

Convert a pipelined table in a ref cursor

Posted on 2012-03-11
4
324 Views
Last Modified: 2013-02-26
Hi,

I would want to know; in Oracle 9i, how I could convert a PIPELINED table in a ref cursor for using of a application developed in .NET.

Thanks.

Javier A. Granda
0
Comment
Question by:javiergrandat
4 Comments
 
LVL 20

Accepted Solution

by:
flow01 earned 250 total points
ID: 37707761
I don't know .NET  but the basic conversion to a ref_cursor would be:

function rc return sys_refcursor
is
  l_cur sys_refcursor;
begin
    open l_cur for (select * from table(pl-function));
    return sys_refcursor;
end;
0
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 250 total points
ID: 37708633
follow flow01 suggestion and after that check the below link

this link has further details on how to use the refcursors in dot net code..

http://www.oracle.com/technetwork/articles/dotnet/williams-refcursors-092375.html
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL syntax check  without executing 6 75
MULTIPLE DATE QUERY 15 91
pl/sql - query very slow 26 74
Oracle cursor lifecycle inside procedure. 2 13
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question