ORACLE | JSON_QUERY with path as variable

Question

Is that possible to pass the variable path on JSON_QUERY? I've tried this

select
   t1.ID,
   JSON_QUERY(PRC_DATA, t2.key WITH WRAPPER)
from
   TEST_JSON T1,
   TEMPLATES T2

But it returns the following error

ORA-40454: path expression not a literal
40454. 00000 -  "path expression not a literal"
*Cause:    The provided path expression was not a literal (a constant).
*Action:   Provide a constant path expression.
Error at Line: 9 Column: 35

I don't want to use Execute Immediate, because I want to INSERT-SELECT this JSON keys into a table.

mark d drake · Accepted Answer · 2017-04-29 04:01:30Z

1

The JSON path expression has to be a literal. We cannot work with case where the path to be evaluated is defendant on some other row, or even the same row.

answered Apr 29, 2017 at 4:01

mark d drake

1,53514 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ORACLE | JSON_QUERY with path as variable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related