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
JSON_TABLE function not supported
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad for Oracle
