Re: Database Function Out Parameters Incorrect?

Nick,
Actually, I agree with your statement. However, when we wrote the application, exceptions would not cross the application- -database boundary very well. Since we needed to have actions invoked and know the result, we used functions in place of procedures, with the return code indicating success or failure of the request. So, along with this apparent bug, it is all really Oracle's fault for not providing a better development environment! Anyway, thanks for your input.

Nick Butcher wrote:
>
> A function should not return a value via a parameter but via its RETURN
> statement (I'm a bit of a purist here). You should be using a stored
> procedure to do what I think you're trying to do.
 

-- 
+-----------------------------------------------------
[Quoted] | Dan Townsend, Supervising Database Architect
| EBMUD Enterprise Object Designer
| voice: (510) 287-0272    fax: (510) 287-0373
+-----------------------------------------------------