A script-enabled browser is required for this page to function properly.

ERROR_TEXT Built-in

Description

Returns the message text of the Oracle Forms error.

Syntax

FUNCTION ERROR_TEXT;

Built-in Type unrestricted function

Enter Query Mode yes

Description

Returns the message text of the Oracle Forms error.

Parameters

none

Usage Notes

You can use this function to test error messages during exception handling subprograms.

ERROR_TEXT Examples

/*

** Built-in: ERROR_CODE,ERROR_TEXT,ERROR_TYPE
** Example: Reword certain FRM error messages by checking
** the Error_Code in an ON-ERROR trigger
** Trigger: On-Error
*/
DECLARE
errnum NUMBER := ERROR_CODE;
errtxt VARCHAR2(80) := ERROR_TEXT;
errtyp VARCHAR2(3) := ERROR_TYPE;
BEGIN
IF errnum = 40301 THEN
Message('Your search criteria identified no matches...
Try Again.');
ELSIF errnum = 40350 THEN
Message('Your selection does not correspond to an employee.');
ELSE
/*
** Print the Normal Message that would have appeared
**
** Default Error Message Text Goes Here
*/
Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt);
RAISE Form_Trigger_Failure;
END IF;


ERROR_CODE Built-in

ERROR_TYPE Built-in