Hello all,
I need help with an Interactive Grid that I want to use with a custom PL/SQL code. I cannot figure out how to write my IF/WHEN exist statement for an update or insert on the Interactive Grid. The reason I need a custom one wrote is I have joined the Interactive Grid with another table to use it's column as a static column on the Interactive Grid. Is this possible?
I've tried several ways to find a fix for my syntax but I am not able to figure out how I am suppose to write it. I have tried using the default DML for the IG but it's giving me an error relating to the Lock Row.
Page:
https://apex.oracle.com/pls/apex/f?p=76139:17:4278858286269::NO:RP,17::
I placed a save button the page to execute the PL/SQL code but my code is incorrect.
Login information:
username: test
password: 123456
workspace: keo