CURSOR as OUT variable in stored procedure

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

CURSOR as OUT variable in stored procedure

kwanma
Hi, does HQSQLDB support or going to support cursor as the OUT varaible? Some like the sys_refcursor in Oracle.

e.g.

CREATE OR REPLACE PROCEDURE myprocedure(
   result OUT cursor
)

Thanks.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: CURSOR as OUT variable in stored procedure

Fred Toussi-2
No cursors as an OUT parameter. But it supports returning multiple
results in procedures or a single result in functions.

Fred

On Fri, Jul 5, 2013, at 8:42, kwanma wrote:

> Hi, does HQSQLDB support or going to support cursor as the OUT varaible?
> Some
> like the sys_refcursor in Oracle.
>
> e.g.
>
> CREATE OR REPLACE PROCEDURE myprocedure(
>    result OUT cursor
> )
>
> Thanks.
>
>
>
>
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/CURSOR-as-OUT-variable-in-stored-procedure-tp3924.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> Hsqldb-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Loading...