Re: Question Regarding: RAISE_APPLICATION_ERROR

David,
  Apparently raise_application_error is not defined inside Forms.   Use RAISE FORM_TRIGGER_FAILURE,MESSAGE & SHOW_ALERT built ins to   inform the user of the problem.
Igal

In article <01bd5f0e$82c3e8e0$af531995_at_aohemd6willid1.DaytonOH.NCR.COM>,   "David Williams" <david.williams_at_daytonoh.ncr.com> wrote:
>
> All,
> 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
> 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;
>
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 03 1998 - 00:00:00 CEST