2 Replies Latest reply on Mar 4, 2014 1:40 PM by Michael Ferrante-Oracle

    run_product is not working in oracle forms 11g

    1010331

      Hi,

          I migrated oracle forms 3.0 to 11g, in 3.0 I can use Run_Product but in 11g it will not support then how to write a code for this program.This is a WHEN-MOUSE-DOUBLECLICK Trigger.

       

      :CURRENT := :HDR.PROG_NO;

      IF :ARA_PROG_ID = 'M' THEN

          SET_BLOCK_PROPERTY('HDR',DEFAULT_WHERE,'PROG_NO IN (SELECT A.PROG_NO FROM MENU_AUTHOR A

      WHERE PARENT = :CURRENT AND

      A.USER_NO = :PARAMETER.PCOMP#)');

      EXECUTE_QUERY;

      ELSE

      if :FUNC_CODE=3 THEN

      Run_Product(REPORTS,:ARA_PROG_ID,SYNCHRONOUS,RUNTIME,FILESYSTEM,TO_CHAR(NULL),NULL);

      null;

      ELSE

      call_form(:ARA_PROG_ID,NO_HIDE,DO_REPLACE);

                END IF;

      END IF;

        help will be appreciable.

                                   Thank you