Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help cannot call a sequence
Are you sure that you granted select on the sequence to the owner of the package?
On 10 Sep 1997 13:25:17 GMT, ptakes_at_xs1.xs4all.nl (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.
Received on Wed Sep 10 1997 - 00:00:00 CDT