Re: RETURN VALUE on Stored Procedures

Fred Toussi via Hsqldb-user <[email protected]> Sat, 06 Jan 2018 14:43:14 +0000
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <1515249794.954561.1226283152.797C8937@webmail.messagingengine.com>
HSQLDB follows the SQL Standard which has no return value for procedures.

Fred

On Sat, Jan 6, 2018, at 14:08, Imran K wrote:
> I think Noel was asking about primitive type return values, not result sets.
> This is allowed in stored procedures in some databases, e.g. SQL Server and
> Sybase.
> 
> I am having a similar problem with Sybase. We have stored procedures that
> modify tables, return values via OUT parameters, and also return primitive
> type values (usually integer error codes) in similar way to a stored
> functions.
> 
> As far as I can see this is not possible with HSLDB. Is this correct?
> 
> 
> 
> --
> Sent from: http://hsqldb.10974.n7.nabble.com/HSQLDB-User-f3.html
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot