IFS8 Custom Menu PL/SQL Block

admin

We are trying to get a RMB to run a customer package.

1. DECLARE
   
2.    PROMO_CODE_IN VARCHAR2(200);
   
3.    SOURCE_IN VARCHAR2(200);
   
4.    ORDER_ID_IN VARCHAR2(200);
   
5.    RETURN_CODE_OUT NUMBER;
   
6.    RETURN_MESSAGE_OUT VARCHAR2(200);
   
7.    CHARGE_TYPE_CODE_OUT VARCHAR2(200);
   
8.    TOTAL_DISCOUNT_AMT_OUT NUMBER;
   
9. BEGIN
   
10.   KOLC.KOLC_PROMOTION_CODE_PKG.GET_PROMO_CODE_DETAILS_PRC( NULL, 'IFS', '&ORDER_NO',RETURN_CODE_OUT,
    
11. RETURN_MESSAGE_OUT,CHARGE_TYPE_CODE_OUT, TOTAL_DISCOUNT_AMT_OUT
    
12.    );
    
13. 
    
14. END;

複製代碼

We are receiving the error illegal procedure.    If you hit the test button in the custom menu screen you get insufficient privilege to access object.
Reading other post we have tried the following.

1. This is an error from the application server for protection against SQL injection in the oracle database. Actually I am not an expert in this technology area of IFS Application, but I will try my best to help you.

Try to refresh the server dictionary cache. You can update the dictionary from the client.
Solution Manager/Administration/Refresh Server Cache [ ] Dictionary

For the dictionary to be updated both in the server and the Application Server the PLSQL AccessProvider must be setup and working.
Verify the PLSQLAccessProvider installation trough Solution Manager/Administration/Monitoring/Application Monitoring Console.
There should be a green light for the Access Provider.

2.DEFINE GRANTEE = IFSSYS

PROMPT Granting to &GRANTEE   BEGIN  Installation_SYS.Grant_Privileged_Grantee('&GRANTEE', TRUE);

END;

/   UNDEFINE GRANTEE

   Your stored procedure will have to contain the module and logical unit info in the package header (check an existing one for an example).


CREATE OR REPLACE PACKAGE &PKG IS module_  CONSTANT VARCHAR2(25) := '&MODULE';lu_name_ CONSTANT VARCHAR2(25) := '&LU';