Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column value Increment on add row button of tabular form

VedantJan 7 2013 — edited Jan 7 2013
Hi,

I am working on apex 4.1.

I am working of tabular form.

mY table name is ACT_SEG
My primary key column name is LINE_ID NUMBER TYPE.


On custom pl/sql function i have written code
declare
abc number;
begin
select NVL(max(line_id),0)+1 into ABC from ACT_SEG;
return abc;
end;
I want to increment mY LINE_ID COLUMN ON ADD ROW BUTTON of tabular form.

But it is Incrementing on submit button.

After inserting one row how i can increment my LINE_ID ON add_row button.


Thansk & Regards
Vedant
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2013
Added on Jan 7 2013
4 comments
1,504 views