My Oracle Support Banner

Unable to invoke a stored procedure with the DB Adapter in SOA 12c (Doc ID 2017647.1)

Last updated on JUNE 03, 2018

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Experiencing a binding issue when invoking a stored procedure from SOA 12c via the DB Adapter which contains complex data types (array, database object) .
 

[2015-03-17T10:44:28.984+11:00] [DefaultServer] [ERROR] [] [oracle.soa.adapter] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: f75c1b8b-5b12-46eb-b37a-adff1611451b-00000cdd,0:2] [APP: soa-infra] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: fabric] [WEBSERVICE.name: bpelprocess1_client_ep] [WEBSERVICE_PORT.name: BPELProcess1_pt] [oracle.soa.tracking.FlowId: 10004] [oracle.soa.tracking.InstanceId: 10012] [oracle.soa.tracking.SCAEntityId: 20010] [composite_name: Sample!1.0] [FlowId: 0000Kk^yMvdDsXG5IzCCyf1L0E6W00000Q] JCABinding=>  Sample:dbReference [ dbReference_ptt::dbReference(InputParameters,OutputParameters) ]  Could not invoke operation 'dbReference' against the 'db' due to: [[
BINDING.JCA-11811
Stored procedure invocation error.
Error while trying to prepare and execute the SAMPLE_PK.SAMPLE API.
An error occurred while preparing and executing the SAMPLE_PK.SAMPLE API. Cause: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SAMPLE'
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SAMPLE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Check to ensure that the API is defined in the database and that the parameters match the signature of the API.  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.

 

 

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
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.