This content has been marked as final. Show 2 replies
I am using Oracle Forms 11g. The module Master-Detail Block, I have created it Manually (Non-Database Item).
One block contains only one record and Other (Detail) Block may contain >=1 Record.
My procedure accepts different parameters/Arguments for Master table and Cursor for Details table.
create or replace procedure Myproc (param1 varachar, param2 number, MyCursorParam Sys_REFCURSOR)
How should I invoke the procedure from oracle forms? how can the datablock(details) converted to Cursor and pass it to the procedure?
I need this because I want to execute the DML from procedure only and also in one transaction.