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!

Passing 1000's of ID's to branch gives APEX.BRANCH.UNHANDLED_ERROR

Hoek2 days ago — edited 44 hours ago

Hi all,

APEX 24.1

DB 19.0

Along the lines of this great example APEX Interactive Grid - Processing Selected Records
( APEX Interactive Grid - Processing Selected Records )
we have an IG which enables our users to select records for further processing. This worked fine, however now the situation occurs where user needs to select 1000 - 3000 records and that seems too much to pass to a branch. The branch is to another page for further processing.

Error: Error processing branch.

- Additional info: Contact your application administrator.

Details about this incident are available via debug id "390280".

- Display location: ON_ERROR_PAGE

- Association type:

- Item name:

- Region id:

- Column alias:

- Row:

- Model instance id:

- Model record id:

- Internal error: true

- Common runtime error: false

- APEX error code: APEX.BRANCH.UNHANDLED_ERROR

- SQL code: -6502

Is there a way to overcome this? Should we use a collection instead or are there any other options to consider?

As always:

Thanks in advance for tips/hints/pointers!

Regards,

Hoek

Comments
Post Details
Added 2 days ago
3 comments
107 views