Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=zapps768; d=zoho.com;
  h=subject:to:references:from:message-id:date:user-agent:mime-version:in-reply-to:content-type;
  b=E9eqdkfHGnDTA7ro68/m8ZRtXRZ4ZMoyhm1rSd4gkfxcGa5UZGU7b1Spx/iw/w6HMgvUU7UZjkyg
    1ymQhUs6quemOduoyoofYikBZoVxpE+vc4WDxr3Zl37ELJ4PlGlB  
Subject: Re: create resultset from user defined system stored procedure
To: derby-dev@db.apache.org
References: 
 <SN1PR0601MB16146CDA666EDDA237579E64F2E00@SN1PR0601MB1614.namprd06.prod.outlook.com>
From: Alex <alex3kov@zoho.com>
Message-ID: <56729C96.3010105@zoho.com>
Date: Thu, 17 Dec 2015 14:29:26 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: 
 <SN1PR0601MB16146CDA666EDDA237579E64F2E00@SN1PR0601MB1614.namprd06.prod.outlook.com>
Content-Type: multipart/alternative;
 boundary="------------000600000407020702070703"

This is a multi-part message in MIME format.
--------------000600000407020702070703
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------000600000407020702070703
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body smarttemplateinserted="true" bgcolor="#FFFFFF" text="#000000">
    <div id="smartTemplate4-template">Hi,<br>
      You can read on stored procedures here:
<a class="moz-txt-link-freetext" href="https://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html">https://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html</a><br>
      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.<br>
    </div>
    <br>
    <div class="moz-signature"><i>--Regards, Alex</i></div>
    <br>
    <div id="smartTemplate4-quoteHeader">
      <hr><br>
      <b>From:</b> Anjana Prakash<br>
      <b>Sent:</b> Thursday, December 17, 2015 2:16PM<br>
      <b>To:</b> Derby-dev<br>
      <b>Subject:</b> create resultset from user defined system stored
      procedure</div>
    <blockquote
cite="mid:SN1PR0601MB16146CDA666EDDA237579E64F2E00@SN1PR0601MB1614.namprd06.prod.outlook.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><o:p>�</o:p></p>
        <p class="MsoNormal">Hi, <o:p></o:p></p>
        <p class="MsoNormal"><o:p>�</o:p></p>
        <p class="MsoNormal">Is there any reference available where in a
          user defined system stored procedure can return resultset.
          <o:p></o:p></p>
        <p class="MsoNormal"><o:p>�</o:p></p>
        <p class="MsoNormal">Thanks,<o:p></o:p></p>
        <p class="MsoNormal">Anjana. <o:p></o:p></p>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------000600000407020702070703--