I have this script that works fine in sql plus but when I attach it to a
procedure in my report it gives me an error
"error 101 Encountered a symbol SELECT when expecting one of the following"
The error surfaces when the bolded line (choosing the date) is included in
the script.
What is t
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
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
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 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