FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception [message #602185] |
Sun, 01 December 2013 00:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/364f02e78e1b19978baeb3d07b455bee?s=64&d=mm&r=g) |
mohammed ibrahem
Messages: 2 Registered: December 2013
|
Junior Member |
|
|
when click button save
insert into details_master
(id,matrials_id)
values
(:id,:ESTBIAN_DATA.MATRIALS_LIST);
insert into estbian
(id,master_id,details_id,detail_name,grade,time_date)
values
(:id,:ESTBIAN_DATA.MATRIALS_LIST,:details_topics.id,:details_topics.detail_name,:details_topics.grade,sysdate);
error message : "FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception
|
|
|
|
|
Re: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception [message #602215 is a reply to message #602211] |
Sun, 01 December 2013 12:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1229663c86eb1a441385fe710cd9116e?s=64&d=mm&r=g) |
mughals_king
Messages: 392 Registered: January 2012 Location: pakistan
|
Senior Member |
|
|
Dear you did not define whether it is multi record block or SINGLE RECORD anyway if it is not multirecord block then your code will work like this.create procedure in "Program Unit"
PROCEDURE ibrahem IS
BEGIN
insert into details_master
(id,matrials_id)
values
(:id,:ESTBIAN_DATA.MATRIALS_LIST);
insert into estbian
(id,master_id,details_id,detail_name,grade,time_date)
values
(:id,:ESTBIAN_DATA.MATRIALS_LIST,
etails_topics.id,
:details_topics.detail_name,
:details_topics.grade,sysdate);
commit
END;
WHEN-BUTTON-PRESSED-->TRIGGER
ibrahem;
if multiple record block then you need LOOP like
Take this examle FMB file and Run
create table test2(id varchar2(6),id_date date);
Result....
SQL> select * from test2;
ID ID_DATE
------ ---------
101 25-APR-12
Regard
Mughal
[Updated on: Sun, 01 December 2013 12:38] Report message to a moderator
|
|
|
|
|
|
|
Re: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception [message #602288 is a reply to message #602280] |
Mon, 02 December 2013 14:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1229663c86eb1a441385fe710cd9116e?s=64&d=mm&r=g) |
mughals_king
Messages: 392 Registered: January 2012 Location: pakistan
|
Senior Member |
|
|
Dear Dear close your book please WHICH you always keeping in your hand reading the question from the forum & answering live in practical as well along with theory and please better do your job and let me do my job. we are not paying members here. let the forum members decide what is wrong and what is right specially those who are asking the questions on this forum instead of asking question to me post your answer and mention mughal you were wrong here if i would wrong I will 100% accept it and will asked you please suggest the correct answer i never feel shame to learn anything from anyone as i told you in my previous posts thats it.take care
" TRIGGER raised unhandled exception
Clear or not
Regard
Mughal
[Updated on: Mon, 02 December 2013 15:16] Report message to a moderator
|
|
|
Re: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception [message #602291 is a reply to message #602272] |
Mon, 02 December 2013 15:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1229663c86eb1a441385fe710cd9116e?s=64&d=mm&r=g) |
mughals_king
Messages: 392 Registered: January 2012 Location: pakistan
|
Senior Member |
|
|
mughals_king wrote on Mon, 02 December 2013 12:34Why not Dear @cookiemonster
"FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception
application design error the current trigger raised an exception other than
form_trigger_failure but it did not handle the exception
Means rewrite the trigger text to handle the exception.
This is my answer and please post your answer and mention where mughal was wrong not for me only for every forum members i hope without reading my Answer you posted your comments.
Best Regards
Mughal
[Updated on: Mon, 02 December 2013 15:50] Report message to a moderator
|
|
|
Re: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception [message #602293 is a reply to message #602291] |
Mon, 02 December 2013 16:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
So you either haven't actually read the description of FRM-40735 or you haven't bothered to think about what it means.
It means there was some other error.
That other error could have been:
ORA-00001
ORA-01400
one of the date conversion errors
mutating table
.....
.....
Any one of 1000's of possible error.
And you and I don't know what the underlying error is.
And without knowing that it isn't possible to suggest a solution, since each possible error requires a different solution.
So the only thing you, I and everyone else can do is wait for the OP to answer the question Littlefoot originally asked:
Quote:
Which unhandled exception is it?
|
|
|
|
|
|