On Thu, Nov 24, 2005 at 09:26:07AM +0100, Frank Motzkat/IC3S AG wrote:
> Hi community,
>
> I would like to declare a function with IN and OUT parameters as well as a refcursor as return value.
>
> For example something like this:
>
> This doesn???t work. It gives the compilation error ???ERROR: function result type must be integer because of OUT
parameters???
<snip>
Well in that case you've said the output is an integer, and you're
returning a refcursor, hence the error. In the second case you don't
have any out parameters, so it understands you're trying to return the
refcursor.
I suppose you could declare the refcursor as an OUT parameter, or
return the integer in the first case,
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.