Nested SELECT expresions in DECLARE CURSOR

[Daniel Rodríguez]

Sorry,

I'm working with HP-UX B.11.11, HP9000, Oracle 10.2 and PowerHouse 8.43.D1

Daniel

2007/7/31, Guy Werry <guy.werry at hbms.ca>:
>
>  Daniel,
>
> 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)!
>
>
> Guy L. Werry
> Senior Systems Analyst
> Hudson Bay Mining & Smelting Co., Limited.
>
>  ------------------------------
> *From:* powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com [mailto:
> powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com] *On Behalf Of *Daniel
> Rodríguez
> *Sent:* Tuesday, July 31, 2007 12:45 PM
> *To:* powerh-l at lists.sowder.com
> *Subject:* Nested SELECT expresions in DECLARE CURSOR
>
> Hi all,
>
> In Oracle I'm able to use nested selects like this one:
>
> select 1 as one, (select 2 from dual d) as two
>  from dual
>
> When I try to do it in a screen I get the following message:
>
> screen kk
> sql in sgtompla &
>  declare csr_example cursor for &
> select 1 , (select 2 from dual d)&
>  from dual
>
>  cursor csr_example primary occurs 12
> *E* Error parsing SQL statement.
> DMS-E-GENERAL, A general exception has occurred during operation 'prepare
> request'.
>   access sequential
>
> It is possible to use this expresion or I'm missing something.
>
>
> Best regards,
>
> Daniel Rodriguez
>
>
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070731/121ffa30/attachment.htm