Nested SELECT expresions in DECLARE CURSOR

[Daniel Rodríguez]

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/4d057af9/attachment.html