I am not getting data when my first field in IG is pop lov i am getting output like
[{"ORGN_TKTL_ATID":{"v":"2022070789","d":"A700-1"},"TTL_PCS":"6","TTL_CRTS":"","INSUM$ROW":1}]
where "v" data shows my return value and "d" is my display value my query is
SELECT a.ORGN_TKTL_ATID,
A.TTL_PCS,
A.TTL_CRTS
FROM json_table(:P22_JTBL, '$[*]'
columns
ORGN_TKTL_ATID number path '$.ORGN_TKTL_ATID',
TTL_PCS number path '$.TTL_PCS',
TTL_CRTS number path '$.TTL_CRTS'
) a
here in this query if i use
A.INSUM$ROW than it gives me error i am unable to run the page
error is
ORA-20999: Failed to parse SQL query! ORA-06550: line 1, column 1: ORA-40597: JSON path expression syntax error ('$.INSUM$ROW') JZN-00209: Unexpected characters after end of path at position 11
this time my query is
SELECT a.ORGN_TKTL_ATID,
A.TTL_PCS,
A.TTL_CRTS,
a.INSUM$ROW
FROM json_table(:P22_JTBL, '$[*]'
columns
ORGN_TKTL_ATID number path '$.ORGN_TKTL_ATID',
TTL_PCS number path '$.TTL_PCS',
TTL_CRTS number path '$.TTL_CRTS',
INSUM$ROW number path '$.INSUM$ROW'
) a
guide me
I am not getting data when my first field in IG is pop lov i am getting output like [{"ORGN_TKTL_ATID":{"v":"2022070789","d":"A700-1"},"TTL_PCS":"6","TTL_CRTS":"","INSUM$ROW":1}] where "v" data shows my return value and "d" is my display value my query is SELECT a.ORGN_TKTL_ATID, A.TTL_PCS, A.TTL_CRTS FROM json_table(:P22_JTBL, '$[*]' columns ORGN_TKTL_ATID number path '$.ORGN_TKTL_ATID', TTL_PCS number path '$.TTL_PCS', TTL_CRTS number path '$.TTL_CRTS' ) a here in this query if i use A.INSUM$ROW than it gives me error i am unable to run the page error is ORA-20999: Failed to parse SQL query! ORA-06550: line 1, column 1: ORA-40597: JSON path expression syntax error ('$.INSUM$ROW') JZN-00209: Unexpected characters after end of path at position 11
this time my query is SELECT a.ORGN_TKTL_ATID, A.TTL_PCS, A.TTL_CRTS, a.INSUM$ROW FROM json_table(:P22_JTBL, '$[*]' columns ORGN_TKTL_ATID number path '$.ORGN_TKTL_ATID', TTL_PCS number path '$.TTL_PCS', TTL_CRTS number path '$.TTL_CRTS', INSUM$ROW number path '$.INSUM$ROW' ) a guide me