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

Last updated on APRIL 22, 2009

Applies to:

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

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms