| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Subquery not valid in a cursor?
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
![]() |
![]() |