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 | 5 years ago
  1. 0

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

    Oracle Community | 5 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 | 5 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 | 11 months 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 2 months ago
  2. Cafecanudo 2 times, last 3 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