Re: Sequences: How to generate outside of default property

Well, I tried the select statment and it appears that I'm getting some kind of PDE 'internal error', somehow emanating from procedure builder. (PDE-PER001 internal error(deplu3)) When I looked this up, it said either a change had been made to a system table by someone (not applicable in this case) or there was a bug and I would have to contact Oracle. Anyone heard of this error and when trying to access a sequence? I ran the same code (without the 'into' part of it) using the sql worksheet and it worked FINE.  When running it within forms, I got the above error. The code I ran: select medical.person_seq.nextval
into :insplan.insplanid
from dual;
Any suggestions?
Lothar Armbruester <lothar.armbruester_at_rheingau.netsurf.de> wrote in article <1134.330T936T12883191_at_rheingau.netsurf.de>...
> On 24-Jan-98 22:55:44 Joanne James wrote:
>
> >Hello... I've set up my sequence to generate up to number x (ie, 99999).
 I
> >want the sequence to get the next number to store in an item only when I
> >press 'Save'.
 

> I don't know if this solves your problem (you are talking about forms,
> possibly Oracle Forms(?) which I have not any experience with.)
>
> Hpoe that helps,
> Lothar
>
> --
> Lothar Armbrüster | lothar.armbruester_at_rheingau.netsurf.de
> Schulstr. 12 | lothar.armbruester_at_t-online.de
> D-65375 Oestrich-Winkel |
>
>
Received on Wed Jan 28 1998 - 00:00:00 CET