My Oracle Support Banner

Problem with Strings Having a Leading "&" (Ampersand Character) (Doc ID 2457161.1)

Last updated on OCTOBER 25, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


On all versions of Oracle Communications Billing and Revenue Management (BRM), strings being stored in the database by the dm_oracle process which start with the "&" (ampersand) character end up being stored with an additional "&".  For example:

1. When creating an account with LASTNAME, ADDRESS, etc with values starting with "&" e.g. "&val1", then a value of "&&val1" is stored in the database.  Notice that system is adding an extra "&" while storing in database.

2. When modifying an account field LASTNAME, ADDRESS, etc using PCM_OP_WRITE_FLDS with a value starting "&" e.g. "&val2", then again a value of '&&val2' is stored in database.  An extra ampersand is again prefixed.


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.