Re: Returning a set of rows from a stored procedure

From: Jyotheesh Sukumaran <jsukumar_at_mail.mia.bellsouth.net>
Date: Sat, 01 Aug 1998 22:41:08 GMT
Message-ID: <35C3C3C4.563DBD97@mail.mia.bellsouth.net>

You need to use DBMS_OUTPUT.PUT_LINE(<variable1> <variable2> ....); There is a limit of 200000 to the number of characters using that statement. So you wont be able to select all the rows from a large table. This is mostly used to output small table values, variable values or error messages.

pax_prakarsa_at_my-dejanews.com wrote:

> What are the ways to return a set of rows, which is a result of a query, from
> a stored procedure, other than using CURSOR, in Oracle ?
>
> Thanks
> Pax
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Aug 01 1998 - 17:41:08 CDT