are they run as the same user - if you dont have select privelege on
the seuqnce then you wont see it in all_sequences
On Thu, 2 Dec 2004 00:59:11 +0800, Sinardy Xing
oracle-l@xxxxxxxxxxxxx
> Select count(*) from all_sequences=20
>
> return 0
>
> Select count(*) from dba_sequences=20
>
> return correct # of sequence
--
http://www.freelists.org/webpage/oracle-l