Re: Bugs in Developer 2000?
Date: 1998/04/18
Message-ID: <35388321.0_at_lightning.ica.net>#1/1
The proposed solution I think it's equivalent to:
select liu.item_id_sequence.nextval into ---
from dual;
Angel.-
> Here is a solution that does not require a database change:
I think that Liping Liu forgot to say the query where to save the returned numbe
r.
>
> declare
> cursor c1 is
> select liu.item_id_sequence.nextval
> from dual;
> begin
> open c1;
> fetch c1 into ---;
> close c1;
> end;
>
> --
> Joe Strano
> Dulcian, Inc.
>
> Liping Liu wrote:
>
> > I have a simple code
> >
> > select liu.itemid_sequence.nextval from dual;
> >
> > for a button. I am puzzled by the so-called internal error (database
> > error) during compiling. I do not have a formal explanation but I have
> > the following workaround:
> >
> > 1) Use SQLPlus to login to Oracle server
> > 2) Create my own sequence like this:
> > create sequence itemid_sequence
> > increment by 1
> > start with 10011;
> > 3) I change the code for Create button as follows:
> > select itemid_sequence.Nextval
> > from dual;
> > 4) Then I get another error saying something about Nextval. So I
> > change Nextval to nextval
>
> > 6) I finally change the code back to my original one:
> > select liu.itemid_sequence.Nextval
> > from dual;
> > 7) It stills compiles without errors
> >
> > Does anybody out there have explanation for the above?.
> >
> > --
> >
> > *************************************************************
> > Liping Liu, Ph.D.
> > Assistant Professor
> > Information Systems
> > Susquehanna University
> > Selinsgrove, PA 17870
> > Tel: 717-372-465
> > Fax: 717-372-4491
> > Email: liu_at_infosys.susqu.edu
> > URL: http://infosys.susqu.edu/liu
> > *************************************************************
>
>
>
>
>
>
Hungry for NEWSGROUPS??? USE feedME.ORG Read and Post to 30,000 groups through feedME.ORG FREE FREE FREE http://www.feedME.ORG FREE FREE FREE ------------------------------------------------------------------Received on Sat Apr 18 1998 - 00:00:00 CEST