Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE your_table (
  signal_id     NUMBER,
  ts_id         NUMBER,
  add_price     NUMBER,
  qty           NUMBER,
  stops         NUMBER,
  yield         NUMBER,
  close_date    DATE,
  close_price   NUMBER,
  ticker        VARCHAR2(10),
  option_ticker VARCHAR2(10),
  signal_date   DATE,
  estimated_reporting_date DATE
);
CREATE PROCEDURE insert_json (i_json IN CLOB)
IS
BEGIN
  INSERT INTO your_table (
    signal_id, ts_id, add_price, qty, stops, yield, close_date, close_price,
    ticker, option_ticker, signal_date, estimated_reporting_date
    /*...*/
  )
  SELECT *
  FROM   JSON_TABLE(
           i_json,
           '$'
           COLUMNS(
             signal_id     NUMBER          PATH '$.signal_id',
             ts_id         NUMBER          PATH '$.ts_id',
             add_price     NUMBER          PATH '$.add_price',
             qty           NUMBER          PATH '$.qty',
             stops         NUMBER          PATH '$.stops',
             yield         NUMBER          PATH '$.yield',
             close_date    DATE            PATH '$.close_date',
             close_price   NUMBER          PATH '$.close_price',
             ticker        VARCHAR2(10)    PATH '$.ticker',
             option_ticker VARCHAR2(10)    PATH '$.option_ticker',
             signal_date   DATE            PATH '$.signal_date',
             estimated_reporting_date DATE PATH '$.estimated_reporting_date'
             -- ...
           )
         );
END insert_json;
/
BEGIN
  insert_json('{
    "signal_id": "1",
    "ts_id": "3",
    "add_price": "0",
    "qty": "1",
    "stops": "0.00",
    "yield": "0.00",
    "close_date": "NULL",
    "close_price": "0.00",
    "ticker": "IBM",
    "option_ticker": "NULL",
    "signal_date": "2012-07-25",
    "estimated_reporting_date": "NULL",
    "signal_val": "1",
    "comp_name": "INTERNATIONA",
    "lt_price": "190.34",
    "sell_target": "NULL",
    "high_target": "NULL",
}');
END;
/
1 rows affected

SELECT * FROM your_table;


SIGNAL_ID
TS_ID
ADD_PRICE
QTY
STOPS
YIELD
CLOSE_DATE
CLOSE_PRICE
TICKER
OPTION_TICKER
SIGNAL_DATE
ESTIMATED_REPORTING_DATE


1
3
0
1
0
0
null
0
IBM
NULL
25-JUL-12
null