2 Replies Latest reply: Feb 5, 2014 6:10 PM by DanielB RSS

    Querying the Non-Database Item

    PrathameshPitale

      Hello,

      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