Question Regarding: RAISE_APPLICATION_ERROR

All,

[Quoted]         Please bear with me here since I am somewhat new to Forms. I am using Forms 5.x and I am trying to write a very simple trigger that selects a username and password from a table. There is a where clause in the select statement that will try to match what has been entered into 2 no database fields (Username and Password) with those existing within a table. Simply put I am trying to match an entered username/password with those I have [Quoted] stored in a table. The trigger looks as follows :-

	begin
  		select user_name, password
  		into   :ENV_USERS.username,
         		 :ENV_USERS.user_password
  		from   env_users
  		where  user_name = :ENV_USERS.username
  		and    password = :ENV_USERS.user_password;

		exception
  		when no_data_found then
    		raise_application_error(-20100, 'Username/Password not valid');

	end;

[Quoted] I am getting the following error and have no idea why ... can anyone help ?????

		Error 201 at line 11, column 5
		  identifier 'RAISE_APPLICATION_ERROR' must be declared.

This is driving me nuts and I'm sure it's a real simple solution.

Dave Williams.
Dave.Williams_at_daytonoh.ncr.com Received on Fri Apr 03 1998 - 00:00:00 CEST