db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anjana Prakash <anjana.prak...@actian.com>
Subject RE: create resultset from user defined system stored procedure
Date Thu, 17 Dec 2015 14:41:27 GMT
Thanks Alex will check on same.

Thanks,
Anjana.

From: Alex [mailto:alex3kov@zoho.com]
Sent: Thursday, December 17, 2015 4:59 PM
To: derby-dev@db.apache.org
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.


Mime
View raw message