How i do it ?

[Aurelio Campos]

-- Seleciono Setor por Setor os Demais Registros e Joins

FOR Reg_Invc_File IN ( SELECT
C.SYS_CARR_NR, D.GRP_FILE_SEQ, D.GRP_FILE_SEQ,
A.ACCT_NR,
A.CMPGN_NR,
(SELECT SUM(ORDER_ITEM.ORD_ITEM_AMT) AS TOT_QTD_ITEM FROM ORDER_ITEM WHERE ORDER_ITEM.ORD_NR_SEQ = A.ORD_NR_SEQ AS TOT_QTD_PED ) AS TOT_QTD

FROM

ORDERS A,
REP B,
PARAMETER C,
INVC_GRP D
WHERE
A.ACCT_NR = B.ACCT_NR AND
B.DSTRCT = Reg_Rep.DSTRCT ) LOOP

HELPE PLEASE... I NOT SPEAK ENGLISH VERRY WEEL... PARDON FOR GRAMATICAL ERROS IN MY TEXT oK ?!
MY PROBLEM IS THE SELECT IN MID OF OTHER SELECT, IN SQL WINDOW IS RIGHT IN PROCEDURE NOT oK, HOW I DO TO IN PROCEDURE MODE THIS SELECT BE RIGHT ?!

TKS FRIENDS...

[This message has been edited by Aurelio Campos (edited 19 August 2003).]

 

[Marco Kalter]

What exactly is the error when you use this select statement in a PL/SQL loop?

------------------
Marco Kalter
Allround Automations

 

[Aurelio Campos]

Tks,
I see in Oracle Documentation and my problem is resolved.
Tks Friend...
See you.

Originally posted by mkalter:
What exactly is the error when you use this select statement in a PL/SQL loop?