Re: Strange PB !?

instead of:

insert into myTable values (last_key_code+1,...);

first create a sequence:

create sequence key_seq;

then something like:

insert into myTable values ( key_seq.NEXTVAL ,...);

randy

Wassim wrote:

> Hi, all
>
> I've in many of my PL/SQL procedures to create a new record in a table
> just with Key code = Last key + 1, (key_code is the table primary key)
>
> to do this i've written the following PL/SQL code :
>
> ------------------------------------------------------------------------
> last_key_code := 0;
> begin
> select max(key_code) into last_key_code from myTable;
> exception when OTHERS then last_key_code:=0; -- when myTable is empty !!
> end;
>
> htp.print(last_key_code);
>
> insert into myTable values (last_key_code+1,...);
> ------------------------------------------------------------------------
>
> When myTable is empty this algorithm never works, when attemping to
> print value to 'last_key_code' in such situation (myTable is empty)
> nothing is printed, and 'insert into' procedure return error !!! i add
> an 'if' statment to make it work but doesn't solve the pb :
>
> ----
> if last_key_code=null then last_key_code:=0; end if
> ----
>
> I think that we can automate such operations by creating a 'sequence' ?
> how ?
>
> Anyone can help please?
> Thanks.
>
> Wassim,
> e-mail: net2000_at_francemel.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Jun 13 1999 - 19:03:33 CDT