2 Replies Latest reply on Feb 6, 2014 12:10 AM by DanielB

    Querying the Non-Database Item



      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)


      //code here



      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.


      Please Guide