SQL Developer (MOSC)

MOSC Banner

JSON notation limit 4000char ORA-40459

edited Jun 30, 2022 4:36PM in SQL Developer (MOSC) 3 commentsQuestion

Extracting data from Oracle 12c database through Oracle SQL Developer using XML works nicely, however I need to convert this into a JSON extracted format and is returning errors.

ORA-40459: output value too large (actual: 4084, maximum: 4000)

40459. 00000 - "output value too large (actual: %s, maximum: %s)"

*Cause:   The provided JavaScript Object Notation (JSON) operator generated a

          result which exceeds the maximum length specified in the RETURN

          clause.

*Action:  Increase the maximum size of the data type in the RETURNING clause

          or use a CLOB/BLOB in the RETURNING clause.

I tested the suggested RETURNING CLOB in each statement section related to arrayagg but still return the above error.

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