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 -
-
Cause
Product Defect - QAT-19907 -
Resolution
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad Data Point.