Re: Using a Sequence from a Form

The most straightforward way is to specify it in the initial (default) value property.
Syntax is :SEQUENCE.<sequence_name>.nextval. <sequence_name> can be either the sequence name on its own or prefixed with the owner name.

Andrew D. Arenson wrote:

> I am developing my first Oracle Form. I'm using an installation of D2K,
> with form4.5 and Oracle7.3 on a Solaris platform.
>
> I have created a block. I would like to have new records in that block
> assigned a unique value out of a sequence.
>
> My guess is that the way to achieve this is to place a trigger on the
> block to catch the event 'ON-INSERT'. I'm not sure, however, what pl/sql
> code to place in that trigger. I don't know what pl/sql code I'm replacing
> if I create a trigger for that event.
>
> Does anyone have any suggestions?
>
> Andy
>
> --
> Andrew D. Arenson | http://gc.bcm.tmc.edu:8088/cgi-bin/andy/andy
> Baylor College of Medicine | arenson_at_bcm.tmc.edu (713) H 520-7392
> Genome Sequencing Center, Molecular & Human Genetics Dept. | W 798-4689
> One Baylor Plaza, Room S903, Houston, TX 77030 | F 798-5386
Received on Wed Aug 26 1998 - 08:34:21 CEST