java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WSH_WSHRDXCP_XMLP_PKG", line 239 ORA-06512: at line 4at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

Oracle Community | EBSDBA | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ava.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character

    Oracle Community | 6 years ago | EBSDBA
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WSH_WSHRDXCP_XMLP_PKG", line 239 ORA-06512: at line 4at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  2. 0

    [052111_121233777][EXCEPTION] SQLException encounter while executing data

    Oracle Community | 6 years ago | oracle_developer
    java.sql.SQLException: ORA-06550: line 2, column 36: PLS-00302: component 'P_LOCAL_LEDGER' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 36: PLS-00302: component 'P_PERIODE' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored
  3. 0

    xml ERROR

    Oracle Community | 5 years ago | 927548
    java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00302: component 'P_MODULE' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 22: PLS-00302: component 'P_STATUS' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 22: PLS-00302: component 'P_ITEM_ID' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Significance of FND_JDBC_PLSQL_RESET

    Oracle Community | 6 years ago | user10088255
    java.sql.SQLException: ORA-20101: ORA-06512: at "APPS.XXAP_APXINAGE_XMLP_PKG", line 302 ORA-06512: at line 4at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  6. 0

    Error In XML Publisher Data Definition

    Oracle Community | 1 year ago | 3130002
    java.sql.SQLException: ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively

  1. balintn 11 times, last 6 months ago
  2. Cafecanudo 2 times, last 6 months ago
18 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WSH_WSHRDXCP_XMLP_PKG", line 239 ORA-06512: at line 4at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

    at oracle.jdbc.driver.DatabaseError.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    5. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    12 frames
  3. oracle.apps.xdo
    JCP4XDODataEngine.runProgram
    1. oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650)
    2. oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263)
    3. oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
    4. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
    5. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
    6. oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
    7. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
    8. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
    8 frames
  4. oracle.apps.fnd
    Run.main
    1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
    1 frame