Return
-
Title
SAP Hana Database Error -
Description
SAP Hana Database Error: sql syntax error: incorrect syntax near..." error message encountered when executing block statement with a Temp table, using SAP Hana connection
Repro Steps -
Start TDP and establish SAP Hana connection
Open SQL Editor and paste following statement:
“DO BEGIN
TESTTABLE=SELECT 'HELLO WORLD!' FROM DUMMY;
SELECT * FROM :TESTTABLE; -- this line creates a syntax error
END;”
Execute statement and for Value in “Bind variables” form, type “address“. Click “OK”
“SAP Hana Database error” is shown below -
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.