Stored Procedure Problem - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial">Hello,</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"><span style="mso-spacerun:
yes">                </span>Atul Here, I have one problem while accessing Database Records Or Recordset from stored
procedure.Procedure is like this,</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal" style="margin-left:.5in"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 
12.0pt;font-family:Arial">CREATE FUNCTION b_function() RETURNS int4 AS '</span></font></span><p class="MsoNormal"
style="margin-left:.5in"><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial">DECLARE</span></font></span><p class="MsoNormal" style="margin-left:.5in"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 
12.0pt;font-family:Arial"><span style="mso-spacerun: yes">   </span>an_integer int4;</span></font></span><p
class="MsoNormal"style="margin-left:.5in"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial">BEGIN</span></font></span><p class="MsoNormal" style="margin-left:.5in"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 
12.0pt;font-family:Arial"><span style="mso-spacerun: yes">   </span>select emp_id from employee;</span></font></span><p
class="MsoNormal"style="margin-left:.5in"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial"><span style="mso-spacerun: yes">   </span>return an_integer;</span></font></span><p
class="MsoNormal"style="margin-left:.5in"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial">END;</span></font></span><p class="MsoNormal" style="margin-left:.5in"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 
12.0pt;font-family:Arial">'</span></font></span><p class="MsoNormal" style="margin-left:.5in"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 
12.0pt;font-family:Arial">LANGUAGE 'plpgsql';</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">I create the procedure . After that I run the statement like</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal" style="text-indent:.5in"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size: 
12.0pt;font-family:Arial">Test=#> select b_function();</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">Error comes like</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black"
face="Arial"size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none;
text-autospace:none"><b><font color="red" face="Default" size="1"><span
style="font-size:8.0pt;font-family:Default;color:red;font-weight:bold">Error:ERROR:<span style="mso-spacerun: yes"> 
</span>SELECTquery has no destination for result data.</span></font></b><p class="MsoNormal"
style="margin-left:.5in;mso-layout-grid-align:none;
text-autospace:none"><b><font color="red" face="Default" size="1"><span
style="font-size:8.0pt;font-family:Default;color:red;font-weight:bold"><spanstyle="mso-tab-count:1">               
</span>Ifyou want to discard the results, use PERFORM instead.</span></font></b><p class="MsoNormal"
style="margin-left:.5in;mso-layout-grid-align:none;
text-autospace:none"><b><font color="red" face="Default" size="1"><span
style="font-size:8.0pt;font-family:Default;color:red;font-weight:bold">WARNING:<spanstyle="mso-spacerun: yes"> 
</span>Erroroccurred while executing PL/pgSQL function b_function</span></font></b><p class="MsoNormal"
style="margin-left:.5in;mso-layout-grid-align:none;
text-autospace:none"><b><font color="red" face="Default" size="1"><span
style="font-size:8.0pt;font-family:Default;color:red;font-weight:bold">WARNING:<spanstyle="mso-spacerun: yes"> 
</span>line4 at SQL statement</span></font></b><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><b><fontcolor="red" face="Default" size="1"><span
style="font-size:8.0pt;font-family:Default;
color:red;font-weight:bold"> </span></font></b><p class="MsoNormal"><span class="EmailStyle15"><font color="black"
face="Arial"size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">Also I use PERFORM statement. But still problem is not resolved.</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">Please Help me. I hope your kind co-operation.</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">Thanks.</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">Atul…</span></font></span></div>