Oracle-L: RE: ref cursor

From: <mail2gkatteri_at_netscape.net>
Date: Tue, 11 Mar 2003 17:33:46 -0800
Message-ID: <F001.00567147.20030311173346@fatcity.com>

SELECT null,null <-- Repeat as many columns as in the original cursor FROM dual
WHERE 1=2 It works.

HTH GovindanK

"Basavaraja, Ravindra" <Ravindra.Basavaraja_at_T-Mobile.com> wrote:

>Hi,
>
>I have a procedure that has an ref cursor as an OUT parameter.If for some reason If I have to return
> NULL values in the ref cursor how do i do that.
>
>Thanks
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Basavaraja, Ravindra
> INET: Ravindra.Basavaraja_at_T-Mobile.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>

Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promos=380455

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: mail2gkatteri_at_netscape.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Mar 11 2003 - 19:33:46 CST