6 Replies Latest reply: May 30, 2012 9:55 AM by 911387 RSS

    Referencing Oracle Forms program units from a library

    911387
      Hi,
      Im using Oracle Forms 10.1.2.0.2. I have declared a procedure in several forms that executes a query and then enables or disables some items depending on the number of query hits. The procedure is always the same and it's something like this:

      PROCEDURE QUERY(prBlock IN VARCHAR2, prQuery IN VARCHAR2) IS
      BEGIN

           SET_BLOCK_PROPERTY(prBlock , ONETIME_WHERE, prQuery);
           GO_BLOCK (prBlock);
      EXECUTE_QUERY();

           ENABLE_ITEMS(GET_BLOCK_PROPERTY(prBlock ,QUERY_HITS) > 0,prBlock);
      END QUERY;

      Problem is that I want to add this procedure to a library, but I can't find a way to call ENABLE_ITEMS so that every form enables/disables their appropiate items. Is there a way to call a procedure declared in a forms program unit from a library?

      Thanks.