Reporting History Exception Character String Buffer Too Small (Doc ID 1065388.1)

Last updated on FEBRUARY 05, 2013

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 and later
Information in this document applies to any platform.
***Checked for Currency on 01-Feb-2013***

Symptoms

An error occurs when running the OMS_REPORT_ORDERS_HISTORY stored procedure:

[java] INFO [main] (TestOrderReport.java:210) - ======================================================================
[java] INFO [main] (TestOrderReport.java:211) - Run: ORDERMGMT_REPORTS.OMS_REPORT_ORDERS_HISTORY
[java] ERROR [main] (TestOrderReport.java:52) - SQLException:
[java] java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
[java] ORA-06512: at "ORDERMGMT_REPORTS.OM_REPORTING_PKG", line 1307
[java] ORA-06512: at "ORDERMGMT_REPORTS.OMS_REPORT_ORDERS_HISTORY", line 9
[java] ORA-06512: at line 1

[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
[java] at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
[java] at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
[java] at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)
[java] at com.didata.za.osm.TestOrderReport.runReportOrdersHistory(TestOrderReport.java:220)
[java] at com.didata.za.osm.TestOrderReport.run(TestOrderReport.java:45)
[java] at com.didata.za.osm.TestOrderReport.main(TestOrderReport.java:279)

Cause

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