Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help cannot call a sequence
Hi, i have a problem on oracle7,
If i refer to a sequence, say, mysequence.NextVal from PL/SQL it
works fine. If i try to address the same sequence from a function
(defined within a package) oracle complains about the non-existence
of this sequence (even if i spell it out as <user>.<sequence>.NextVal,
how do i solve this?
Thanks in advance. Received on Wed Sep 10 1997 - 00:00:00 CDT