Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help cannot call a sequence

Help cannot call a sequence

From: ptakes <ptakes_at_xs1.xs4all.nl>
Date: 1997/09/10
Message-ID: <5v673t$fjt$1@news0.xs4all.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US