Development notes, tips and tricks for Oracle's HTML DB

Tuesday, June 29, 2004

Update primary key with sequence number

To dynamically set a primary key column to a sequence number, add a page process that fires 'On Submit - After Computations and Validations' before the 'Process Row of [table]' process.
Use a PL/SQL statement that selects the sequence.nextval into the primary key column:

if :P3_EMPNO is null then
select ct_id_seq.nextval into :P3_EMPNO from dual;
end if;

Make sure to use the if statement. If you don't then you will encounter No-data-found errors.

2 Comments:

Anonymous Anonymous said...

Flieger,

I saw your post
regarding search .

You are welcome to place a link to
your blog or website on our high
traffic website for free. See:

http://www.quickregister.net/infowizards


We have a specific category for search .
Your listing will be indexed in the search
engines under search . It will
also be a permanent link.

Thank you,

John,

http://www.quickregister.net
Free Search Engine Submission Service.

11:28 AM

 
Anonymous Anonymous said...

Flieger,

I took a look at your post
regarding promoter .

You are invited to place a link to
your blog on our website for free. See:

http://www.quickregister.net/infowizards


We get over 18,000 visitors per day.
Many are looking for promoter
related products and services.

We have a specific category for promoter .
Your listing will be spidered by the search
engines under promoter . Our pages
are made to be search engine friendly.
We hope you take a moment to take
advantage of this free advertising.

Cheers,

John

http://www.quickregister.net
Free Search Engine Submission Service.

10:23 AM

 

Post a Comment

<< Home