"ORA-01722: invalid number" Error is Generated when Creating a New Calling Card Subscriber
Last updated on SEPTEMBER 16, 2016
Applies to:Oracle Communications Network Charging and Control - Version: 2.2.0
Information in this document applies to any platform.
GeneralccsAccountWithPrivacy.sh is the ccsAccount tool which have following functions:
- Set the initial wallet state to a configurable value, when creating new Calling Card subscribers. i.e. to something like "Frozen"
- Add a new command line option to allow specified serial number ranges, to have their state changed. i.e. to "Active" or "Pre-use"
Problem DescriptionWhen attempting to create new Calling Card Subscriber through usage of ccsAccountWithPrivacy.sh, the script fails to complete, with an oracle error output such as:
smf_oper@sms01:/IN/service_packages/CCS/bin> ./ccsAccountWithPrivacy.sh GPG-Key Test -s 207000000000 -e 207000020000 -c "Currency" -n 5000 -C 5 -t "CallingCard" -d -B 1 -u -w frozen
Jun 22 07:37:04.537309 ccsAccount(10772) NOTICE: Number of accounts pre-allocated at a time=100
Jun 22 07:37:05.761500 ccsAccount(10772) ERROR: An Oracle error ocurred that the program did not expect:
Jun 22 07:37:05.761774 ccsAccount(10772) ERROR: SQL error code -1722 at ccsAccountSQL.pcc:52
Jun 22 07:37:05.761920 ccsAccount(10772) ERROR: SQL error: ORA-01722: invalid number
Jun 22 07:37:05.762076 ccsAccount(10772) ERROR: SQL statement: select count(*) into :b0 from ccs_acct_reference where (to_number(account_number)>=to_number(:b1) and to_number(account_number)<to_number(:b2))
Jun 22 07:37:05.762224 ccsAccount(10772) ERROR: Aborting program
Complete descriptions about what is Calling Card and how to used ccsAccountWithPrivacy.sh are available in article Doc ID 1273689.1
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