EBS Customizations (MOSC)

MOSC Banner

ORA-40491: invalid input data type for JSON_TABLE Rest Service Parameter

Working with EBS 12.2.10 and 19c (19.10.0.0.0) I want to pass json array in a rest api. But I am getting following error:

ORA-40491: invalid input data type for JSON_TABLE

When I manually run JSON_TABLE query it successfully parse data but when passing through parameter it shows mentioned error.

Please have a look for details mentioned in attachment.


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