Re: SEQUENCE

From: Prasad Chavali <pchavali_at_assettech.com>
Date: 15 Jul 1998 09:45:00 -0700
Message-ID: <6oimac$gvc@nntp02.primenet.com>

If you are using forms for inserting records then do

select SeQ_name.nextval from dual into :you_block.seq_id_column.

Write an exception to this statement so that if somebody without access to this sequence tries to execute this, they will know what's going on.

HTH Prasad Chavali
John Bester wrote in message <35ad2235.0_at_informer.hixnet.co.za>...
>Hi,
>
>I need an example on how to use a SEQUENCE. (Actually, the sequence is not
>so difficult - my problem is the trigger) What I want to do is to set an ID
>column to the next value in a sequence in an (BEFORE?) INSERT trigger.
>
>---
>John Bester
>johnb_at_iconnect.co.za
>
>
>
Received on Wed Jul 15 1998 - 11:45:00 CDT