NewBie Help
From: William Teo <sucheeha_at_singnet.com.sg>
Date: Thu, 30 Dec 1999 12:11:30 +0800
Message-ID: <84emdd$ggp$1_at_clematis.singnet.com.sg>
Hi,
I have written the following g simple function and I have received the following error
ERROR 201 AT LINE 12, COLUMN 3
IDENTIFIER "SET_ALERT_PROPERTY" MUST BE DECLARED ERROR 0 AT LINE 12, COLUMN 3
STATEMENT IGNORE Any reason why I can't use the set_alert_property function within the function.
Date: Thu, 30 Dec 1999 12:11:30 +0800
Message-ID: <84emdd$ggp$1_at_clematis.singnet.com.sg>
Hi,
I have written the following g simple function and I have received the following error
ERROR 201 AT LINE 12, COLUMN 3
IDENTIFIER "SET_ALERT_PROPERTY" MUST BE DECLARED ERROR 0 AT LINE 12, COLUMN 3
STATEMENT IGNORE Any reason why I can't use the set_alert_property function within the function.
thanks
William
/*FUNCTION OF THIS FUNCTION IS TO TEST WHETHER
THE GLOBAL VARIABLES :GLOBAL.ITM_CODE OR :GLOBAL.BRD_CODE IS NULL*/
FUNCTION PARA_IS_NULL RETURN BOOLEAN IS
alert_id ALERT := Find_Alert('GENERIC_ALERT');
dummy_var NUMBER;
BEGIN
/*VARIABLE DEFINITELY EXITS CAUSE IT HAS BEEN DECLARED IN PRE-FORM, NO TEST
REQUIRED*/
IF :GLOBAL.ITM_CODE IS NULL OR :GLOBAL.BRD_CODE IS NULL
THEN
SET_ALERT_PPOPERTY(alert_id, TITLE, 'Invalid Item Code');
SET_ALERT_PPOPERTY(alert_id, ALERT_MESSAGE_TEXT, 'Item Code is not valid.
Key in another one.');
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
NULL;
END;
Received on Thu Dec 30 1999 - 05:11:30 CET