Thanks Alex will check on same. Thanks, Anjana.
From: Alex [mailto:[email protected]] Sent: Thursday, December 17, 2015 4:59 PM To: [email protected] Subject: Re: create resultset from user defined system stored procedure 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.
