How To Handle Data Fields Larger Than 255 Characters (Doc ID 809983.1)

Last updated on AUGUST 28, 2023

Applies to:

Goal

ASAP has a restriction of 255 characters of the fields in ASAP schema. This note details how to handle data that exceeds this length.

For instance when have the following scenarios:

1) The upstream system was sending an attribute whose length was 512 and the order was failing
because of length restriction.

2) We had to fetch some data from IPSA and modify it and then update IPSA again. When the length
of data (CONFIG_POLICY_CONTENT_VALUE - XML data type) exceeds 255, the characters are stripped while sending it back.

A varchar2 field (which is storing the value of ASDL parameters) can support more than 255 (in
oracle 8 and higher) and we need A5 to support it.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.