艾歐踢論壇

標題: IFS8 Custom Menu PL/SQL Block [打印本頁]

作者: admin 時間: 2017-6-11 20:52
標題: IFS8 Custom Menu PL/SQL Block
We are trying to get a RMB to run a customer package.

DECLARE
PROMO_CODE_IN VARCHAR2(200);
SOURCE_IN VARCHAR2(200);
ORDER_ID_IN VARCHAR2(200);
RETURN_CODE_OUT NUMBER;
RETURN_MESSAGE_OUT VARCHAR2(200);
CHARGE_TYPE_CODE_OUT VARCHAR2(200);
TOTAL_DISCOUNT_AMT_OUT NUMBER;
BEGIN
KOLC.KOLC_PROMOTION_CODE_PKG.GET_PROMO_CODE_DETAILS_PRC( NULL, 'IFS', '&ORDER_NO',RETURN_CODE_OUT,
RETURN_MESSAGE_OUT,CHARGE_TYPE_CODE_OUT, TOTAL_DISCOUNT_AMT_OUT
);
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';

歡迎光臨艾歐踢論壇 (http://www.iot.idv.tw/ucenter/)