I have a requirement in which I have to have a form on two table and insert data in which on 1 table has PK which Fk to other table .
And I need to get the PK back to apex so that i can navigate further after successful insert/update.
Methods i tried.
1) Used a view on two table for insert and then created instead of trigger to insert .
issues -- Work fine until i tried to use returning to apex app as it returning into is not support by instead of trigger.
2)Created a procedure to insert and then return PK back to apex.
issues-- Form on procedure cannot be used for EDIT purpose.
seeking you expertises on this so that i can do insert/update on two different tables (through view) and get the PK value returned back to apex.
4.1.1 11gr2 linux oc4j
thanks 4 your time.
Edited by: Hunk09 on May 21, 2013 5:47 PM
1. create a form on the view
2. create a manual plsql process for condition :request = 'CREATE' using your function and saving the returning PK in your item
3. for condition :request in ('SAVE,DELETE') use the default automatic row process