Re: CURSOR as OUT variable in stored procedure
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1373190960.30226.140661252751777.229F6B69@webmail.messagingengine.com> |
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 > [email protected] > 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