Re: Bugs in Developer 2000?

Now I have more workarounds but still no explanations. Creating a synonym certaintly works. However, with the original code:

select liu.itemid_sequence.nextval
into :block_item.text_itemid
from dual;

When I compile it right in the editor, I get PDE-PER0001 Internal error (deplu 3). However, if I close it and use File->Compile All, it works.

squigley_at_sctcorp.com wrote:

> In article <3534E037.41DE9BE6_at_infosys.susqu.edu>,
> liu_at_infosys.susqu.edu wrote:
> The problem you are experiencing has to do with the multiple embedded
> periods. Forms can only handle one. If you create a synonym for the
> sequence and access it via the synonym, the problem should go away.
>
> Steven J. Quigley
> Principal Technical Specialist
> SCT
>
> >
> > 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
> > *************************************************************
> >
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

--

*************************************************************
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
*************************************************************