You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Anjana Prakash <an...@actian.com> on 2015/12/17 12:16:30 UTC

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.

RE: create resultset from user defined system stored procedure

Posted by Anjana Prakash <an...@actian.com>.

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.

Re: create resultset from user defined system stored procedure

Posted by Alex <al...@zoho.com>.

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.
>