Home » Developer & Programmer » Forms » 100501 non oracle exception !
100501 non oracle exception ! [message #217395] Fri, 02 February 2007 00:31 Go to next message
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 #217423 is a reply to message #217395] Fri, 02 February 2007 02:22 Go to previous messageGo to next message
Littlefoot
Messages: 19351
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I saw this error only once (it means that I don't code much Smile). 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.

I really wouldn't know how to explain it (and why exception handling section isn't Oracle exception (?!?)), but ... that's what happened here. Perhaps you'll be able to figure something out.
Re: 100501 non oracle exception ! [message #217749 is a reply to message #217423] Mon, 05 February 2007 04:37 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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

Previous Topic: conversion problem
Next Topic: How to hide/overwrite default tool bar
Goto Forum:
  


Current Time: Sat Aug 02 04:49:53 CDT 2014

Total time taken to generate the page: 0.08095 seconds