Re: Question Regarding: RAISE_APPLICATION_ERROR

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.williams_at_daytonoh.ncr.com> wrote >>
>
> 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
>
Received on Mon Apr 06 1998 - 00:00:00 CEST