Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help cannot call a sequence
ptakes wrote:
>
> 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.-----------------------------------------------------
try creating a public synonym for the sequence... it should work in
the same manner as a global variable.
Received on Thu Sep 11 1997 - 00:00:00 CDT