| oracle forms and database triggers problem [message #178111] |
Mon, 19 June 2006 07:42  |
ashosheh
Messages: 25
Registered: June 2006
Location: JOR
|
Junior Member |
|
|
hello
I created a (before insert or update [for each row]) database trigger on my table , the trigger works as follows: if checking condition in the trigger fails , I raise an application error with 20002 code and an error message, otherwise I insert or update records.
In SQL-PLUS everything works fine and the error message is printed when the trigger fails, but...
In form builder ... when i create an insert datablock on this table , if inserted values matches the database trigger condtion, everything works fine and rows are inserted/updated. but if those values does not match ,the form does not print the error message which i specified in the database trigger,it prints a (successful operation completion) message but no values were saved in the table.
i tried to use ON_ERROR trigger but also didn't work.
plz tell me if anybody has the solution.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
