How load JSON file into external table

Asked Apr 28 '17 at 20:56

Active Apr 29 '17 at 00:24

Viewed 421 times

We had an old framework which reads the data from external table and processes it. Now I want to use the same but this time I will get data from Handsontable Json. Here I want to do it in a bulk insert into external table so that it's easy for me to use the existing framework.

FROM json_table(p_transaction,
    '$.massARData[*]'
    COLUMNS(sysName PATH '$.sysName',
            erpTaxCode PATH '$.erpTaxCode',
            taxengTaxCode PATH '$.taxengTaxCode',
            txnDate PATH '$.txnDate',
            taxPointDate PATH '$.taxPointDate

edited Apr 29 '17 at 00:24

Nathan Tuggy

2,237
27
30
38

asked Apr 28 '17 at 20:56

Shiv

You can't insert into an external table. The task is going to be to write to the file, using [`utl_file`](http://docs.oracle.com/database/121/ARPLS/u_file.htm) if you're driving this from the db. – William Robertson Apr 29 '17 at 08:33
An oldie but goodie: http://www.oracle-developer.net/display.php?id=425 – William Robertson Apr 29 '17 at 09:12

How load JSON file into external table

0 Answers0