Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: subqueries in cursors?

Re: subqueries in cursors?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/01/09
Message-ID: <34b68593.14858815@inet16>#1/1

On Fri, 09 Jan 1998 14:29:43 +0100, Peter Rak <prak_at_vsz.sk> wrote:

>
>
>Thomas Kyte wrote:
>
>> On Thu, 08 Jan 1998 17:17:29 GMT, Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de
>> (Gerhard Moeller) wrote:
>>
>> >Hi,
>> >
>> >I just experienced that there are no subqueries allowed in PL/SQL
>
> Hi,
>But try this one:
>
>declare
> cursor foo is
> select DUMMY from ( select DUMMY from DUAL WHERE UPPER(DUMMY)='Y');
>begin
> for x in foo loop
> dbms_output.put_line( x.DUMMY );
> end loop;
>end;
>
>Why it doesn't work???
>I can't use function on column in subquery...
>
> Peter.

That would be bug 388972 after looking into it. Patches exist if you call support.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US