Forms 6i Menu Question
Date: Mon, 22 Oct 2001 11:31:00 -0700
Message-ID: <3BD465E4.185AB4E6_at_dfrc.nasa.gov>
Any ideas as to what I am doing wrong here?
I am new to Forms and Reports and having trouble calling a report object
from a menu attached to a form.
The code that attempts to call the report is in a procedure in a pl/sql
library attached to the menu.
Procedure is as follows:
PROCEDURE DO_TEST_REPORT IS v_plist_id PARAMLIST;
v_p1 VARCHAR2(30);
v_repobj_id REPORT_OBJECT;
v_repins_id VARCHAR2(100);
BEGIN v_plist_id := GET_PARAMETER_LIST('rpt_params');
IF NOT ID_NULL(v_plist_id) THEN
DESTROY_PARAMETER_LIST(v_plist_id);
END IF;
v_plist_id := CREATE_PARAMETER_LIST('rpt_params');
v_p1 := NAME_IN(':PARAMETER.P_CONTRACT_CODE');
ADD_PARAMETER(v_plist_id, 'P_CONTRACT_CODE', TEXT_PARAMETER, v_p1 ) ;
v_repobj_id := FIND_REPORT_OBJECT('RPT_FUND_BY_RAD'); v_repins_id := RUN_REPORT_OBJECT(v_repobj_id, v_plist_id);
END;
The library compiles without error; however, when I run it I get:
FRM 21011: PL/SQL unhandled exception ORA-06508
ORA-06508: PL/SQL: could not find program unit being called Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.
I even comment-out these two lines with no success:
v_repobj_id := FIND_REPORT_OBJECT('RPT_FUND_BY_RAD'); v_repins_id := RUN_REPORT_OBJECT(v_repobj_id, v_plist_id);
The code runs perfectly "as-is" from a button on the form, but does not when called from the library. Received on Mon Oct 22 2001 - 20:31:00 CEST