ORA-00604

OWB 11.2 Mapping Deployment Fails With ORA-00604 error occurred at recursive SQL level 1 And ORA-06502: PL/SQL: numeric or value error: character string buffer too small [ID 1464727.1]

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later

Information in this document applies to any platform.

Symptoms

Deployment of an OWB mapping fails with :

 java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 9

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1477)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:392)
at oracle.wh.runtime.platform.adapter.odb.OdbDeploymentAdapter.deployScript(OdbDeploymentAdapter.java:892)
at oracle.wh.runtime.platform.adapter.odb.OdbDeploymentAdapter.deployScriptList(OdbDeploymentAdapter.java:786)
at oracle.wh.runtime.platform.adapter.odb.OdbDeploymentAdapter.deployScriptList(OdbDeploymentAdapter.java:757)
at oracle.wh.runtime.platform.adapter.odb.OdbDeploymentAdapter.deploy(OdbDeploymentAdapter.java:501)
at oracle.wh.runtime.platform.service.controller.DeploymentController.deploy(DeploymentController.java:216)
at oracle.wh.runtime.platform.service.controller.DeploymentController.deploy(DeploymentController.java:41)
at oracle.wh.runtime.platform.service.DeploymentManager.run(DeploymentManager.java:51)
at java.lang.Thread.run(Thread.java:595)

Cause

 A Database SYSTEM TRIGGER designed to capture DDL may not be coded to account for large package sizes.

Solution

• Check with the DBA for DDL Trigger enabled
• Disable, Drop or Correct the DDL Trigger
• Redeploy the mapping