Subject: Problem PRE-FORM and Stored Procedure

From: <barry_chase_at_my-dejanews.com>
Date: Tue, 27 Oct 1998 15:48:50 GMT
Message-ID: <714q12$mcd$1_at_nnrp1.dejanews.com>

Subject: Problem PRE-FORM and Stored Procedure

I have created a procedure called POP_LIST, which 3 parameters are passed and then populate a list_item. When running under debug, it runs fine without error, but when under normal conditions it displays error :

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.

Action:        Check that all referenced programs, including
                      their package bodies, exist and are compatible.

POP_LIST exists as an attached library. It almost appears as if it is going to fast... which sound absurd to me, but I am at a loss. My PRE-FORM trigger loads several lists prior to form load.

Library procedure:

PROCEDURE POP_LIST(v_RECORD_GROUP IN VARCHAR2, v_DATA_BLOCK IN VARCHAR2, v_LIST_ITEM IN VARCHAR2) IS

        result	number;
        value	varchar2(46);  /* Must match Column Specification from Record

Group Props. */

BEGIN result := Populate_Group(v_RECORD_GROUP);

        IF result <> 0 THEN
           MESSAGE('Error populating record group');
           RAISE FORM_TRIGGER_FAILURE;
        ELSE
	   Clear_List(v_DATA_BLOCK||'.'||v_LIST_ITEM);
	   Populate_List(v_DATA_BLOCK||'.'||v_LIST_ITEM, v_RECORD_GROUP);
	   value := Get_List_Element_Value(v_DATA_BLOCK||'.'||v_LIST_ITEM, 1);
        END IF;

END; PRE-FORM trigger:

POP_LIST('APPS_PROGRAMMER_ID_REC','APPLICATION_MSTR','PROGRAMMER_ID');
POP_LIST('APPS_ACCESS_USER_ID_REC','SEC_FORMS_MSTR','USER_ID');
POP_LIST('APPS_ACCESS_USER_ID_REC','SEC_APPS_MSTR','USER_ID');
POP_LIST('APP_ACCESS_APPLICATION_ID_REC','APPLICATION_MSTR','APPLICATION_ID');
POP_LIST('APP_ACCESS_APPLICATION_ID_REC','APP_FORMS_MSTR','APPLICATION_ID');
POP_LIST('APP_ACCESS_APPLICATION_ID_REC','SEC_APPS_MSTR','APPLICATION_ID');
POP_LIST('APP_ACCESS_APPLICATION_ID_REC','SEC_FORMS_MSTR','APPLICATION_ID');
POP_LIST('FORMS_APPLICATION_ID_REC','APP_FORMS_MSTR','FORM_ID');
POP_LIST('FORMS_APPLICATION_ID_REC','SEC_FORMS_MSTR','FORM_ID');
POP_LIST('FORMS_SEC_USERS_ID_REC','SEC_FORMS_MSTR','USER_ID');
POP_LIST('FORMS_SEC_USERS_ID_REC','SEC_APPS_MSTR','USER_ID');
POP_LIST('FORMS_SEC_APPLICATION_ID_REC','APPLICATION_MSTR','APPLICATION_ID');
POP_LIST('FORMS_SEC_APPLICATION_ID_REC','APP_FORMS_MSTR','APPLICATION_ID');
POP_LIST('FORMS_SEC_APPLICATION_ID_REC','SEC_APPS_MSTR','APPLICATION_ID');
POP_LIST('FORMS_SEC_APPLICATION_ID_REC','SEC_FORMS_MSTR','APPLICATION_ID');
POP_LIST('SEC_FORMS_FORM_ID_REC','APP_FORMS_MSTR','FORM_ID');
POP_LIST('SEC_FORMS_FORM_ID_REC','SEC_FORMS_MSTR','FORM_ID');

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

Received on Tue Oct 27 1998 - 16:48:50 CET