My Oracle Support Banner

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

Last updated on AUGUST 28, 2023

Applies to:

Oracle Communications ASAP - Version 5.2.4 and later
Information in this document applies to any platform.
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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