Getting a format error with a JSON function (4378476)

Getting a format error with a JSON function (TIMESTAMP(6))

Steps to reproduce the problem:

1)Type the code below in the editor

SELECT data_json, created_at
  FROM JSON_TABLE(
            l_clob,
            '$[*]' COLUMNS (
                data_json CLOB PATH '$.data_json',
                created_at TIMESTAMP(6) PATH '$.created_at'
            )
       );

2)Format returns an error although the code compiles correctly

Click To See Full Image.

JSON_TABLE function not supported

WORKAROUND

None

STATUS

Waiting for fix in a future release of Toad for Oracle