Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Creating Dynamic Labels from database table

Mark.ThompsonMar 2 2017 — edited Mar 5 2017

Running Apex 4.2.3.00.08 on Windows Server 2008 and Oracle Database 11.2.0.1.0

I am working through the instructions in this blog entry to try to create dynamic field labels:

http://apexbyg.blogspot.com/2012/10/dynamically-changing-item-labels.html

I have hit a snag. The following two lines in the Oracle function are causing me grief, because they are preventing the function from returning any data from the apex_application_page_items table:

       where pi.application_id = v('APP_ID')

         and pi.page_id = v('APP_PAGE_ID')

I have tried v(...) as well as nv(...), and they both return the same error, indicating that the function returned zero rows. 

I found the culprit lines of code by replacing v('APP_ID') with 113 (hard-coding the application number), and removing the second line altogether, which made it work fine.  So there obviously is something wrong with the way I'm trying to pass in the APP_ID and the APP_PAGE_ID.

Any thoughts?
This post has been answered by fac586 on Mar 3 2017
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2017
Added on Mar 2 2017
#apex-discussions
22 comments
3,000 views