db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex <alex3...@zoho.com>
Subject Re: create resultset from user defined system stored procedure
Date Thu, 17 Dec 2015 11:29:26 GMT
Hi,
You can read on stored procedures here: 
https://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html
They are supposed to be returning a Derby data types (except BLOB, CLOB, 
LONG VARCHAR, LONG VARCHAR FOR BIT DATA, and XML) in SQL expressions, so 
I don't think returning a ResultSet makes any sense here.

/--Regards, Alex/

------------------------------------------------------------------------

*From:* Anjana Prakash
*Sent:* Thursday, December 17, 2015 2:16PM
*To:* Derby-dev
*Subject:* create resultset from user defined system stored procedure
>
> Hi,
>
> Is there any reference available where in a user defined system stored 
> procedure can return resultset.
>
> Thanks,
>
> Anjana.
>


Mime
View raw message