You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: