# Code Analysis not able to understand json\_table gives syntax error

**URL:** <https://forums.toadworld.com/t/code-analysis-not-able-to-understand-json-table-gives-syntax-error/45847>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 7, 2019, 1:12pm UTC](https://forums.toadworld.com/t/code-analysis-not-able-to-understand-json-table-gives-syntax-error/45847 "2019-03-07T13:12:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shre.wad](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@shre.wad](https://forums.toadworld.com/u/shre.wad)\
**Post date:** [March 7, 2019, 1:12pm UTC](https://forums.toadworld.com/t/code-analysis-not-able-to-understand-json-table-gives-syntax-error/45847/1 "2019-03-07T13:12:54Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [March 8, 2019, 9:22pm UTC](https://forums.toadworld.com/t/code-analysis-not-able-to-understand-json-table-gives-syntax-error/45847/2 "2019-03-08T21:22:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![shre.wad](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@shre.wad](https://forums.toadworld.com/u/shre.wad)\
**Post date:** [March 11, 2019, 11:24am UTC](https://forums.toadworld.com/t/code-analysis-not-able-to-understand-json-table-gives-syntax-error/45847/3 "2019-03-11T11:24:02Z")

</div>

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