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
![]() |
![]() |