Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TO_NUMBER:ORA-01481: invalid number format model

User_VF18KNov 23 2022

Hi,
I have a problem，Could you give me some hint, please!
Call the interface OCINumberFromText to convert the string to oracle numeric，Error will be reported when the string number exceeds 63 bits。
Refer to the official document to know that the interface actually calls TO_ NUMBER Processing。
TO_NUMBER TEST：
SQL> SELECT TO_NUMBER('1234567890123456789012345678901234567890123456789012345678901234', '9999999999999999999999999999999999999999999999999999999999999999') "Value" FROM DUAL;
SELECT TO_NUMBER('1234567890123456789012345678901234567890123456789012345678901234', '9999999999999999999999999999999999999999999999999999999999999999') "Value" FROM DUAL
*
ERROR at line 1:
ORA-01481: invalid number format model

Comments

Processing

Post Details

Added on Nov 23 2022
#oracle-call-interface-oci
0 comments
508 views