My Oracle Support Banner

Null Array Failing From AOIC To Oracle DB Failing With Error "java.sql.SQLException: ORA-06550: line 1, column 36: PLS-00302: component" (Doc ID 2504233.1)

Last updated on JANUARY 18, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

Symptoms

Issue:

Calling a stored procedure with empty array results error.

ERROR
-----------------------
2019-02-07T19:36:40.600+00:00] [oiciad1I_server [NOTIFICATION] [] [oracle.osb.logging.pipeline] [tid: 170] [userId: <USERID>] [ecid: <ECID>,0:4:1] [APP: Service Bus Framework Starter Application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FlowId: <FLOWID>]  [null, null, null, ERROR] [ICS Activity Stream Logging]: [Code:CREATE_OR_UPDATE_FINANC_RESPON][Version:02.00.0000][Instance:][Operation:test12_REQUEST][ActionID:Ei0][ActionName:test12]: Error Occurred While Invoking test12 Application.
[2019-02-07T19:36:40.600+00:00] [oiciad1I_server] [NOTIFICATION] [] [oracle.osb.logging.pipeline] [tid: 170] [userId:<USERID>] [ecid: <ECID>:4:1] [APP: Service Bus Framework Starter Application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FlowId: <FLOWID>_Jc]  [null, null, null, ERROR] [ICS Tracing Enabled]: [Code:CREATE_OR_UPDATE_FINANC_RESPON][Version:02.00.0000][Instance:][Location:Error Occurred While Invoking test12 Application.][Operation:test12_REQUEST][ActionID:Ei0][ActionName:test12]: [[
Fault:
<soap-env:Fault xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"><faultcode xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">soap:Server</faultcode><faultstring>ICS runtime execution error</faultstring><detail><ICSfaultVar/><reason>oracle.tip.adapter.sa.api.JCABindingException: Stored procedure invocation error. Error while trying to prepare and execute the LAUREATEDEV.ICSDBA_983127479.PZ_PERSON_M$P_CREATE_PERSON API. An error occurred while preparing and executing the LAUREATEDEV.ICSDBA_983127479.PZ_PERSON_M$P_CREATE_PERSON API. Cause: java.sql.SQLException: ORA-06550: line 1, column 36: PLS-00302: component 'PZ_PERSON_M$P_CREATE_PERSON' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Check to ensure that the database objects exists(stored procedures,table,view..etc) in the database and the parameters match the signature of the API-like not exceeding the column range or is not NULL or is already existing value.Please examine the error message carefully to determine a resolution. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-6550" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ORA-06550: line 1, column 36: PLS-00302: component 'PZ_PERSON_M$P_CREATE_PERSON' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Fault Details : &lt;err:serviceInvocationError xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault"&gt; &lt;err:type&gt;Stored procedure invocation error&lt;/:Application Error</reason><operation>test12_REQUEST</operation><request_payload/></detail></soap-env:Fault>
]]

 

STEPS TO REPRODUCE

-------------------------

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.