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!

Character limit length in PL/SQL Code Editor in Oracle APEX page

NagababuAOct 9 2018 — edited Oct 16 2018

Hi,

We have some special case where we need to call some procedures to insert, update and delete procedure during save process in the APEX designer page. For these procedures we need to pass more than 400 parameters. These parameters are page items which contain some dynamic values based on modified or inserted records.Currently, the code included in pl/sql editor is exceeding 5000 characters length, but looks like editor allows only 4000 characters length at max. I cannot move any of this code into a DB package, as these are page items which carry some dynamic values.

Can you please suggest any direct or workaround solution? I need to provide some fix as early as possible.

Thank you in advance!

Regards

--Babu

Comments
Post Details
Added on Oct 9 2018
6 comments
8,115 views