Forms based on PL/SQL Package
glauserSep 12 2011 — edited Sep 27 2011Hi all
I investigate Forms Blocks with DML Data Target Type = "Procedure". We want move business logic that is currently located in various row-level-triggers on the DB into PL/SQL-packages.
I wonder if DML Returning Value really does not work when I insert the data through a Procedure. I found no statement about it in the documentation (clearly, it works only with DB 8i and newer, but we are on 11g now). The Signature of the PL/SQL Procedure for Insert
procedure do_insert (p_tab_test in out tab_test) is...
with it's in out parameter suggests somewhat Returning DML to work. I wonder if it should be possible to expand the Oracle-generated insert procedure like
DECLARE
bk_data PA_TEST.TAB_TEST;
BEGIN
PLSQL_TABLE.POPULATE_TABLE(bk_data, 'BLOCK2', PLSQL_TABLE.INSERT_RECORDS);
PA_TEST.DO_INSERT(bk_data);
PLSQL_TABLE.POPULATE_BLOCK(bk_data, 'BLOCK2') ; -- <-----------------------suggested new line
END;