| 100501 non oracle exception ! [message #217395] |
Fri, 02 February 2007 00:31  |
oracle06
Messages: 36
Registered: December 2005
|
Member |
|
|
Hello All,
I am getting 100501:non oracle exception ,when I am saving records on key-commit trigger.
on this trigger I am calling a procedure named 'save',and from this procedure some other procedure calls exist.when I commit the changes key-commit trigger fires,after successful execution of some procedures in save proceure the data of the detail block
disappears.
how to know,why data is disappearing in detail block.because of this happening this if statment fails.
if :tool_blk.a= :tool_blk.b then....
please reply !!
Thnaks.
|
|
|
|
|
|
| Re: 100501 non oracle exception ! [message #217749 is a reply to message #217423] |
Mon, 05 February 2007 04:37  |
oracle06
Messages: 36
Registered: December 2005
|
Member |
|
|
Thank you Littlefoot,
I have handled that error by writting the if statment at another place.
Now please guide me to solve my another problem that is
I am copying date value in another item on when-check-box-changed by using namein and copy builtin,date is copying correctly but the problem is that when I check the check-box then the records in detail block are not comming where check
box is checked in master block,and if I remove the coding of when-check-box then records are comming.
what should I do to solve it?
please reply asap.
Thank you.
|
|
|
|
| Re: 100501 non oracle exception ! [message #217960 is a reply to message #217749] |
Tue, 06 February 2007 04:22 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Why do you guys insist on doing everything manually. Just let Forms do the work for you.
If you a problem with your code, then post it in the thread so we can SEE what you are doing. NO PSEUDO CODE!!
David
Upd: typo.
[Updated on: Tue, 06 February 2007 04:22] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
). There were two FOR loops; one of them was raising form_trigger_failure which propagated to the calling procedure. In my case, error was solved when I kicked out the WHEN OTHERS exception.