Toad World® Forums

Code Analysis not able to understand json_table gives syntax error


#1

Hi All,

Current TOAD version: 12.6.0.53 Professional Edition.

We are using TOAD code analysis to review our code from last 6 months.

We have now started using json_table but I think TOAD don’t like the syntax of json_table.

select jt.phones
from j_purchaseorder,
json_table(po_document, ‘.ShippingInstructions' columns (phones varchar2(100) format json path '.Phone’)) as jt;

It gives below syntax error.

[Error] Syntax check (2: 18): ERROR: line 2, column 18, ending line 2, column 18: Found ‘(’: Expecting: end-of-input -or- FOR ORDER -or- INTERSECT MINUS UNION -or- CONNECT GROUP HAVING START -or- , WHERE -or- AS CROSS FETCH FULL identifier INNER JOIN LEFT LOCATION LOG MATCH_RECOGNIZE MODEL NATURAL OFFSET OUTER PARTITION PIVOT RETURN RETURNING RIGHT SAMPLE SUBPARTITION UNPIVOT USING VERSIONS

Is there any way around this?

Thanks in advance for your help!


#2

Toad Version 12.6.x was built in 2014 … slightly outdated …

When I parse the given statement using the parser of that overly old Toad version (I took QP5 version 5.269) then I get exactly the same error.

The recent releases parse your statement most fine (however after replacing the Word-style quotes by regular single quotes - perhaps due to copy paste into TW).

Hope this helps,
Andre


#3

Thanks Andre. It did help!!!

I’ ll check with our organisation to see if they can upgrade to latest version, which I think they don’t as it might cost for upgrade.

Thanks,
Shre