Skip to Main Content

Oracle Forms

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!

How to display S.no adjacent to employees table help plsss

610795Mar 20 2008 — edited Mar 24 2008
In a form in tabular format Emp details are displayed

Adjacent to the table i want to put a Sno display item showing
1 for 1st employee
2 for 2nd employee ......

I thought i could like create a global variable in a package specification in a program unit and assign it to 1

Package pack1 is

v_num number :=1;

end;

and then write a PRE_ITEM trigger for a Sno item in the object navigator

In the trigger

how to display the value inside v_cnt;

I tried creating a sequence
create sequence v_seq;

but the sequence really wont help me as
it would keep on incrementing

so how can i display the value inside the v_cnt in a item

Is it possible not to use a trigger and still achieve this
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2008
Added on Mar 20 2008
7 comments
600 views