In an IG, I select records (row selector) and save them in a text item; there are several records chosen. How can I process the said item (varchar2) in PL/SQL to insert the records in an oracle table?
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
In which format you saved on the selection of the IG?
If you have just used a field value separator like a comma or colon, you can query as following:
Jorge.criv
Here is an example of the generated JSON:
Vinish Kapoor
You can query the above JSON data with the following SQL:
Output:
You can use the above SQL query for a cursor, then loop through the cursor records and insert it into the table.
Jorge.criv
Thank you very much for the quick answer