Re: Bugs in Developer 2000?
From: Joe Strano <jstrano_at_dulcian.com>
Date: 1998/04/17
Message-ID: <6h8896$6r3_at_bgtnsc03.worldnet.att.net>#1/1
begin
open c1;
fetch c1 into ---;
close c1;
end;
Date: 1998/04/17
Message-ID: <6h8896$6r3_at_bgtnsc03.worldnet.att.net>#1/1
[Quoted] 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:Received on Fri Apr 17 1998 - 00:00:00 CEST
> 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
> *************************************************************