Nested SELECT expresions in DECLARE CURSOR

[Daniel Rodríguez]

Hi Joe,

I used the DUAL table as a general example.

If I declare a CURSOR with the expresion "SELECT 1 from DUAL", it works so
that's not the problem.

Thank you,

Dani



2007/7/31, Joe Boyle <atla38 at dsl.pipex.com>:
>
>  I suspect that dual is'nt known by PH and you have to return values from
> DUAL via a stored procedure call.
>
>
>  ------------------------------
>
> *From:* powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com [mailto:
> powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] *On Behalf Of *Daniel
> Rodríguez
> *Sent:* 31 July 2007 18:45
> *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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070731/bf99b0fc/attachment.html