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!

Creating View / Materialized Views in PL/SQL Function Body APEX

Dj SteeleMay 2 2018 — edited May 15 2018

Hello Community,

I have a Question in regards to Creating Views/Materialized Views in APEX; I have a lot of Repeat Code to Display the Status of Refund. For the most part All the Code is the Same

Except for the referenced Page Items in Where Clauses

Also to Note: The Reason I'm Creating the Views is due to the Number of Characters Allowed in PL/SQL Function Bodies in APEX Error: "Value too long by 1006 characters!"

How would I Create the Views and Still Account for the Different Page Items ? (See Screen Shots Below)

Would Each View be Created Seperately and Independent of each other ;

Mainly to solve "Value too long by 1006 characters!"

Secondly to Condense Code.

pastedImage_0.png

VS.

pastedImage_1.png

This post has been answered by Scott Wesley on May 2 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2018
Added on May 2 2018
2 comments
551 views