Re: Select doesn't work correctly with user-defined function in select list
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1995/08/21
Message-ID: <41abh7$ehf_at_bytor.lerc.nasa.gov>#1/1
Date: 1995/08/21
Message-ID: <41abh7$ehf_at_bytor.lerc.nasa.gov>#1/1
Hello, Marty:
I too had a similar problem. Unfortunately I can neither remember the details nor re-create it. However, it did have to do with an exception being raised within a function invoked by a select statement.
All I can suggest is that you try encapsulating the function's select statement within an anonymous block and move the exception handling within that block. Have the return statements execute with the outer (function) block. Also, ensure it *is* a singleton select, and also supply the pragma you appear to be lacking.
Regards,
-- ------------------------------------------------------------Received on Mon Aug 21 1995 - 00:00:00 CEST
| Gary Gapinski | email: gapinski_at_lerc.nasa.gov |
| NASA Lewis Research Center | voice: +1 216 433 5251 |
------------------------------------------------------------