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!

referencing apex items from packaged pl/sql

630131Oct 7 2010 — edited Oct 7 2010
I have several processes for a tabular form based on a collection. For a bext practice, I would like to take all the code and place in one pl/sql package and just call the package from the different process points.

What would I need to change in the code to have it run as a package?

For example to reference the

- apx_items: apex_application.g_fxx

- collection, I would still refernce thru api(apex_collection).

- other page items? Would a bind variable refernece work? :p1_empno for example work? Or do I use the &item. notation? &p1_empno. or do I use the v('item') notation type.

- request values such as :request to view what button request is active?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2010
Added on Oct 7 2010
1 comment
2,011 views