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:
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
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