Re: The usage of UNION in a curosor for Pro*C programs

From: DES1 <des1_at_leading.net>
Date: Fri, 4 Sep 1998 10:11:02 -0400
Message-ID: <6sotd7$fln@news.southeast.net>

Hi,
I am trying to use the UNION 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 seperately. We checked in the ORACLE manuals and we could not find any specific ways of using unions in the cursors declarations.

Any help on this greatly appreciated.

Viren & Raj
email: des1_at_southeast.net
BCBSF Received on Fri Sep 04 1998 - 09:11:02 CDT