Referencing Oracle Forms program units from a library
911387May 29 2012 — edited May 30 2012Hi,
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.