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 -> Subquery not valid in a cursor?

Subquery not valid in a cursor?

From: sylvain tremblay <syltrem_at_videotron.ca>
Date: Wed, 3 Apr 2002 22:44:48 -0500
Message-ID: <t0Qq8.42841$Be7.2073405@weber.videotron.net>


Hi

From the doc, subqueries are valid inside the FROM and WHERE clause but can someone tell me if this is valid? I get an error at compile time. If it`s not valid, then how should I do this kind of query in PL/SQL ?

Thanks
Syltrem

        Cursor  Open_Order_Cur
        is      Select  ORDER_NUMBER, SALES_ORDER_TYPE,
                        CUSTOMER_REFERENCE, ORDER_DATE, USERNAME,
                        WEIGHT, VOLUME, SOP_ORDER_TOTAL_CURRENCY,
                        STATUS_FLAG,
                        (Select Count(*)
                        From    FINANCE.SALES_ORDER_LINES L
                        Where   L.COMPANY_CODE = H.COMPANY_CODE
                          And   L.DIVISION = H.DIVISION
                          And   L.ORDER_NUMBER = H.ORDER_NUMBER)
                From    FINANCE.SALES_ORDER_HEADERS H
                Where   H.COMPANY_CODE = P_Company
                  And   H.DIVISION = P_Division
                  And   H.CUSTOMER_NUMBER = P_Customer_Id
                  And   H.STATUS_FLAG <> 'C';
Received on Wed Apr 03 2002 - 21:44:48 CST

Original text of this message

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