Question Regarding: RAISE_APPLICATION_ERROR

[David Williams]

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.W...@daytonoh.ncr.com

[ig...@healthstreet.com]

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$af53...@aohemd6willid1.DaytonOH.NCR.COM>,

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading

[Andrea Cannaos]

David,
try DBMS_STANDARD.raise_application_error (..)

It works for me.

Andrea

[Mark Powell]

Try dbms_standard.raise_application_error(.... If I remember right, forms
does not like packages in the form owner.pkg_name.proc_name so I believe
that you will also need a public or private synonym on sys.dbms_standard.
We had this problem in Forms 3.0 and this fixed it. I imagine that we
carried this forward into our 4.5 code, but I do not code forms so can not
guarantee that it will work.

David Williams <david.w...@daytonoh.ncr.com> wrote >>