Sorry,<br><br>I'm working with HP-UX B.11.11, HP9000, Oracle 10.2 and PowerHouse 8.43.D1<br><br>Daniel<br><br><div><span class="gmail_quote">2007/7/31, Guy Werry <<a href="mailto:guy.werry@hbms.ca">guy.werry@hbms.ca
</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Daniel,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">It would help people a great deal if you would post the
Operating System, Platform and Version (e.g., HP-Ux v10.2, Ph
7.33.D3)!</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">
<p><font size="2">Guy L. Werry<br>Senior Systems Analyst<br>Hudson Bay Mining
& Smelting Co., Limited. </font></p></font></span></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
powerh-l-bounces+guy.werry=<a href="mailto:hbms.ca@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">hbms.ca@lists.sowder.com</a>
[mailto:<a href="mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com</a>] <b>On Behalf Of
</b>Daniel Rodríguez<br><b>Sent:</b> Tuesday, July 31, 2007 12:45
PM<span class="q"><br><b>To:</b> <a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br><b>Subject:</b> Nested SELECT
expresions in DECLARE CURSOR<br></span></font><br></div>
<div><span class="e" id="q_1141d667272ca424_3"><div></div>Hi all,<br><br>In Oracle I'm able to use nested selects like this
one:<br><br><span style="font-style: italic;">select 1 as one, (select 2 from
dual d) as two</span><br style="font-style: italic;"><span style="font-style: italic;"> from dual</span><br style="font-style: italic;"><br>When I try to do it in a screen I get the
following message:<br><br><span style="font-style: italic;">screen kk<br>sql in
sgtompla &<br> declare csr_example cursor for & <br>select 1 ,
(select 2 from dual d)&<br> from dual<br> <br> cursor
csr_example primary occurs 12<br><span style="color: rgb(255, 0, 0);">*E* Error
parsing SQL statement.</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">DMS-E-GENERAL, A general exception has occurred
during operation 'prepare request'.</span><br style="color: rgb(255, 0, 0);">
access sequential<br></span><br>It is possible to use this expresion or I'm
missing something. <br><br><br>Best regards,<br><br>Daniel
Rodriguez<br><br><br></span></div>The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.
</div>
</blockquote></div><br>