Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!e1g2000hsh.googlegroups.com!not-for-mail
From: boopathi.it@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: union all in proc*c
Date: Mon, 19 Nov 2007 20:57:29 -0800 (PST)
Organization: http://groups.google.com
Lines: 11
Message-ID: <e1250c6e-f7b9-4775-9a74-9dd8507e6922@e1g2000hsh.googlegroups.com>
NNTP-Posting-Host: 220.225.212.5
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1195534650 23879 127.0.0.1 (20 Nov 2007 04:57:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 20 Nov 2007 04:57:30 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e1g2000hsh.googlegroups.com; posting-host=220.225.212.5; 
 posting-account=GZqN6woAAAA7IJWHAwtthhPN611O8l4X
User-Agent: G2/1.0
X-HTTP-Via: 1.0 MDC3-ISA
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 2.0.50727),gzip(gfe),gzip(gfe)
Content-Disposition: inline
Xref: usenetserver.com comp.databases.oracle.misc:250688
X-Received-Date: Mon, 19 Nov 2007 23:57:30 EST (text.usenetserver.com)

I am trying to use the UNION ALL in a CURSOR declaration. It compiles
fine and
when we run the program it fetches only the rows corresponding to the
first
query in the cursor statement. We do not get any rows corresponding to
the
second query. But we know that second query can fetch some rows if
executed in the ORACLE environment and we could not find any
specific ways of using union all in the cursors declarations.

Any help on this greatly appreciated.