non-Oracle exception -100501 ... most strange
Jan Gelbrich
I would like to ask if somebody ever had
observed an error as "non-Oracle exception -100501".
All that I can say is that I have one user who can
*sometimes* produce this error simply by filling items (afaics in apprpriate
manner, everthing looks ok).
Once I was sitting just besides him, and I cannot reproduce this error.
He ends up with the message that the
record cannot be stored. It is definitely the most strange
thing I ever saw in Forms Runtime. On my developement PC,
I never had this error.
Any hints are greatly appreciated.
TIA, Jan Gelbrich
P.S.:
Oracle 8.1.7 on AIX 4.3.3, Dedicated Server
C/S-Forms 5.0 (I know it is desupported, but I have no choice) on Windows
clients
A 2-tab-Form on two tables with M-D-Relation.
Andrew Hardy
"Jan Gelbrich" <j_gel...@westfalen-blatt.de> wrote in message
news:b6ru2n$884uo$1...@ID-152732.news.dfncis.de...
> Hello,
>
> I would like to ask if somebody ever had
> observed an error as "non-Oracle exception -100501".
>
> All that I can say is that I have one user who can
> *sometimes* produce this error simply by filling items (afaics in
apprpriate
> manner, everthing looks ok).
>
> Once I was sitting just besides him, and I cannot reproduce this error.
>
> He ends up with the message that the
> record cannot be stored. It is definitely the most strange
> thing I ever saw in Forms Runtime. On my developement PC,
> I never had this error.
>
Have a look at FORMS50_USEREXITS in the registry and see if the path exists.
Andy
Jan Gelbrich
but unfortunately, FORMS50_USEREXITS does not exist, neither on my
development PC nor on his.
And as far as I checked both about forms keys, they are the same.
Meanwhile I found a hint that "non-Oracle exception -100501" is indicating
something invalid about the current record ...
I use a PU where I check some items if they are NULL, and if so, I
explicitly raise Forms_Trigger_Failure.
But I have no clue why this may lead to -100501, nor what to do about it ...
it is not documented anywhere,
googling around was not successful either, and at OTN I am still waiting for
any hints ... seems to be a most
rare error.
So I would be glad to find somebody in *this* group.
TIA, Jan Gelbrich
"Andrew Hardy" <spam.fr...@AdvanticaTech.com> schrieb im Newsbeitrag
news:b6s3l5$10q$1...@sun-cc204.lut.ac.uk...
Jan Gelbrich
non-Oracle exception -100501 seems to indicate an inappropriate
exception programming when using raise form_trigger_failure.
(found something like that at metalink)
I had a long If-Block checking various rules to be met by the current
record,
and if not met, I raise form_trigger_failure, maybe 20 times in that PU.
But form_trigger_failure *is* a non-Oracle exception (it is user-defined),
and so there must not be an exception WHEN OTHERS, which will
then always be caught. So the exception is now simply set to
PU_Check_A_Bunch_Of_Rules_Before_Committing
--huge If-Elsif-Block, rules are complicated and some mutually dependend.
ElsIf :Block.Record_Field_XYZ does no meet rule122
Then
Message ...
Raise form_trigger_failure; --Stop all actions to allow user for
making correct inputs.
ElsIf ...and so on
Exception
When Others Then
Null;
--in order not to propagate it to the rest of the actions
End;
I am not sure if this exactly *was* the reason to throw -100501, but
afterwards the symptom dissapeared.
What is left is a strange feeling what to do with eventual circumstances
that are usually caught by When Others,
which cannot be caught any longer this way inside the PU because it does now
Null ...
Any comments on this would be much appreciated.
TIA, Jan
brownky
oh - i know i used the wrong quotes - but it fails with the right
onces as well
--
Posted via http://dbforums.com
brownky
I've been having this problem intermittantly as well with code in
libraries i.e.
copy("yes", name_in('global.var');
some work other fail
its not name_in thats failing its the copy - ive debugged an it always
crashed out on the copy
Any thoughts?