Re: Strange PL/SQL error
From: Tommy Wareing <p0070621_at_oxford-brookes.ac.uk>
Date: Tue, 17 May 1994 08:32:42 GMT
Message-ID: <CpxuEI.5ut_at_uk.ac.brookes>
Date: Tue, 17 May 1994 08:32:42 GMT
Message-ID: <CpxuEI.5ut_at_uk.ac.brookes>
Paul Mickel (mickel_at_sulaco.OES.ORST.EDU) wrote:
> My co-worker and I found an interesting PL/SQL error not too long ago
> in one of our triggers. The error is:
> "PL/SQL Check #20112: Contact your Oracle Representative ... "
The one that plagued me for a while was caused by: a:=a+SIGN(b-a); -- move a 1 closer to b This did cause a PL/SQL check, but I can't remember the number.
The instructions I got from the help desk where simply to comment out bits of code until I isolated the error. Not a great help.
-- _________________________ __________________________________________ / Tommy Wareing \ / In the beginning, there was The Bomb \ | p0070621_at_brookes.ac.uk X And The Bomb said "Let there be Light!" | \ 0865-483389 / \ - The Bomb, Dark Star / ~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Tue May 17 1994 - 10:32:42 CEST