Searches the list of editors and returns an editor ID when it finds a valid editor with the given name. You must define an appropriately typed variable to accept the return value. Define the variable with a type of Editor.
FUNCTION FIND_EDITOR
(editor_name VARCHAR2);
Built-in Type unrestricted function
Returns Editor
Enter Query Mode yes
/*
** Built-in: FIND_EDITOR
** Example: Find and show a user-defined editor
*/
DECLARE
ed_id Editor;
status BOOLEAN;
BEGIN
ed_id := Find_Editor('Happy_Edit_Window');
IF NOT Id_Null(ed_id) THEN
Show_Editor(ed_id, NULL, :emp.comments, status);
ELSE
Message('Editor "Happy_Edit_Window" not found');
RAISE Form_Trigger_Failure;
END IF;
END;