Hi
Copied Get_IG_Data query from browser console, pasted in Execute PL/SQL DA true action, enclosed in a for i in.. loop, and assigning a value to a page item. Error message when trying to check/compile code: "ORA-06550:line 69: column 3:PL/SQL:ORA-40442: JSON path expression syntax error('$INSUM$ROW')ORA-06550:line 3, column 2: PL/SQL:SQL statement ignored. If INSUM$ROW is commented out of select and JSON path statement code checks ok, no error.
Thoughts?
Thanks
Joe
Hi Copied Get_IG_Data query from browser console, pasted in Execute PL/SQL DA true action, enclosed in a for i in.. loop, and assigning a value to a page item. Error message when trying to check/compile code: "ORA-06550:line 69: column 3:PL/SQL:ORA-40442: JSON path expression syntax error('$INSUM$ROW')ORA-06550:line 3, column 2: PL/SQL:SQL statement ignored. If INSUM$ROW is commented out of select and JSON path statement code checks ok, no error. Thoughts? Thanks Joe