Re: Bugs in Developer 2000?

From: Joe Strano <jstrano_at_dulcian.com>
Date: 1998/04/20
Message-ID: <6hgbbi$15q_at_bgtnsc02.worldnet.att.net>#1/1


Sure, but I never use implicit cursors. That's just my coding style. My point to Liping was to use a cursor to get the sequence number and File | Compile All would compile it ok.

--
Joe Strano
Dulcian, Inc.
--------------------------
arojo_at_feedME wrote:


> The proposed solution I think it's equivalent to:
> select liu.item_id_sequence.nextval into ---
> from dual;
> I think that Liping Liu forgot to say the query where to save the returned numbe
> r.
>
> Angel.-
>
> > Here is a solution that does not require a database change:
> >
> > 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
> > > 5) I now can compile the code correctly.
> > > 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 Mon Apr 20 1998 - 00:00:00 CEST

Original text of this message