EBS Customizations (MOSC)

MOSC Banner

JSON Array not passing in rest api

in EBS Customizations (MOSC) 4 commentsAnswered ✓

With EBS 12.2.10 and database 19c (19.10.0.0.0) I deploed a rest api with CLOB parameter in which passing a json array. Log file shows following details which indicates that parameter did not passed correctly:

<oracle.tip.adapter.db.sp.AbstractStoredProcedure execute> BEGIN APPS.XRCL_CB_INBOUND_TEST_PKG.TALLYQUANTITY(P_TRANSACTION_LINES=>?, X_RESPONSE_CODE=>?, X_RESPONSE_MESSAGE=>?); END;

<oracle.tip.adapter.db.sp.AbstractStoredProcedure execute> Bindings [P_TRANSACTION_LINES=>CLOB(<TRANSACTION_TYPE>IO</TRANSACTION_TYPE>), X_RESPONSE_CODE<=VARCHAR2, X_RESPONSE_MESSAGE<=VARCHAR2]

where P_TRANSACTION_LINES is json array parameter.

What may be the reason for this issue?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center