Showing posts with label ORA-06502. Show all posts
Showing posts with label ORA-06502. Show all posts

Tuesday, April 16, 2013

The problem of strings with more than 4000 chars in different regions

When you create an object (item, process, validation, ...) in APEX with the application builder there are properties like messages, conditions and comments. These properties using a string with more than 4000 characters will encounter an error like that:

Even when you use an item Value like


 and the value of this item is longer than 4000 characters, it will result in runtime in this error:

In my case i had to print out a message for the user which could be longer than the 4000 characters.
One solution for my case was to use jQuery and Dynamic Actions to print out the content of an item.
I created the Dynamic Action on the Global Page (Page 0) with these attributes:
The JavaScript Code is:  $('.uMessageText').append($v('P0_TEST'));
Of course there are other ways like described in my oracle-forum thread, but i hope the next apex versions will solve these problems.

Wednesday, February 13, 2013

Error when updating Static File Comment in APEX 4.2.1

Today i played around with updating static files in APEX. Using apex.oracle.com with version 4.2.1 i got an error when updating a static file comment. I simply uploaded a file and afterwards i tried to change the comment. The comment which was initially submitted was saved, but any change results in:
Error updating file.
ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275 ORA-06512: at "SYS.DBMS_LOB", line 884 ORA-06512: at "APEX_040200.WWV_FLOW_HTML_API_PRIVATE", line 144 ORA-06502: PL/SQL: numeric or value error