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.

boopathi.it (AT) gmail (DOT) com wrote:
No Oracle version number
No DDL
No DML

How would you like us to help you with the problem: Guess?

Try taking the two halfs of the statement and run them separately
in SQL*Plus. What happens?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

check maybe you have ; after first query

Uzytkownik <boopathi.it (AT) gmail (DOT) com> napisal w wiadomosci
news:e1250c6e-f7b9-4775-9a74-9dd8507e6922 (AT) e1g2000hsh (DOT) googlegroups.com...