I have a requirement to retrieve and update data from a collection in oracle package runtime. These fields are not stored anywhere in database.
For e.g.
I have a datawindow with columns (say id , name , address)
I want to display values into this datawindow from output of the oracle package procedure, something like below
procedure get_data(argument in number, datawindow_data out <collection>)
Also for updating I would like to call a package procedure sending all the data from datawindow to run updates on a third party system.