Forms 6i Menu Question

From: George E. Gifford <george.gifford_at_dfrc.nasa.gov>
Date: Mon, 22 Oct 2001 11:31:00 -0700
Message-ID: <3BD465E4.185AB4E6@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 - 13:31:00 CDT