Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

creating error message in enter query mode

622131Sep 1 2008 — edited Sep 2 2008
Hello experts,
I want to create an error message in a enter query mode.Suppose i have a field dob and the data filled
in the database in this fasion 01-jan-2008.

Suppose in the enter query mode some one enter the value 01/01/2008.It is not a suitable input for the system .For this error i want to create a error message.

I have written this code

if :system.mode = 'ENTER-QUERY' then
if error_type='FRM' and error_code=40358 then
message('please enter date as 01-jan-2008');
end if;
end if;

The trigger i have used is KEY-EXEQRY.but it is not showing any error when ever i give a input like 01/01/2008.


can you please suggest what's wrong in the coding.

Regards
Anutosh
This post has been answered by 611407 on Sep 1 2008
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 30 2008
Added on Sep 1 2008
6 comments
589 views