I don't think, inline views work in a procedure, he said with a 75% confidence level.
Their use here is suspect anyway.
AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE BETWEEN (SELECT
TO_DATE('01' || SUBSTR(TO_CHAR(SYSDATE),3,9)) FROM DUAL)AND (SELECT
LAST_DAY(SYSD
Title: RE: HELP !!! scrpt works with sql plus but not in a procedure
see answer below
> -Original Message-
> From: Mark Liggayu [mailto:[EMAIL PROTECTED]]
>
> I have this script that works fine in sql plus but when I
> attach it to a
> procedure in my report it
I have had this problem before as well. I do not know if it the only way,
but my solution was to include those two internal SQL statements as part of
the from and then use the variable.
i.e.
INSERT INTO AWW_ISSUED
SELECT ALL
INV.MTL_MATERIAL_TRAN
It may not be the real fix but you need a space before 'RECEIVED'
on line 3.
line 3: SUM(INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY) RECEIVED.
Another thing: you don't need to say ALL in your select. ALL is a default.
-Original Message-
Sent: Wednesday, June 13, 2001 5:52 PM
To