on 05-05-2017 7:19 AM
Hi experts, I just want to know if it is possible to used function inside temp table?
CREATE PROCEDURE "SBODEMOAU"."test" AS (in oCardCode varchar(50))
BEGIN
l_data = SELECT SUM("DocTotal") "Sum_amount" FROM OINV WHERE "CardCode" = :oCardCode;
CREATE LOCAL TEMPORARY TABLE "#TempVat" AS (SELECT * FROM :l_data);
SELECT * FROM #TempVat;
DROP TABLE "#TempVat";
);
END
I've received this error:
Could not execute 'CREATE PROCEDURE "SBODEMOAU"."test" (in oCardCode varchar(50)) As BEGIN l_data = SELECT ...'
SAP DBTech JDBC: [7]: feature not supported: Cannot use local temporary table inside a procedure/function: #TEMPVAT
Problem solved. Need to put double quote on the temp table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.