Re: declare function with IN and OUT parameter as well as refcursor

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(at)svana(dot)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.