This discussion is archived
6 Replies Latest reply: Apr 16, 2013 7:06 AM by OliverL RSS

PL/SQL process returning message with more than 4000 chars

OliverL Newbie
Currently Being Moderated
In our apex application we are using a pl/sql process returning a message.

This message should be shown to the user.

Our problem is now, that the application items in APEX seem to be limited to 4000 chars and the message can be longer.

We are also not able to use a collection, because we can't print the content of a collection in the "Process Success Message".

Here is the content of a page process which is running on page load after header:
Name - Type:     PL/SQL anonymous block
Source - Process: :AI_TEST := p0001_pkg.get_text;
Messages - Process Success Message: &AI_TEST.

Image from process [https://twitter.com/OliverLemm/status/324058809138032640/photo/1/large]

If the page is called the result is this error message:



ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Technical Info (only visible for developers)

is_internal_error: false
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 16433072916569237418
component.name: get_text
error_backtrace:

ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 100
ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 141

Edited by: Oliver L on 16.04.2013 09:17

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points