Toad World® Forums

Code does not run / work with F5, but in HANA Studio

Hi,

this code


do begin
declare v_i integer;
for v_i in 1..12 do delete from SCHEMANAME.TABLENAME where PERDE = v_i;
commit;
end for;
end;

does not work / run in TOAD
error : SAP Hana Database Error: sql syntax error: line 2 col 13 (at pos 23)

when I copy this code 1:1 to HANA Studio and press F8 in HANA Studio it works.

Is there a option to run this code like in HANA Studio?

Holger

Hi, which version of HANA and Toad are you running?

Hi,

Toad is : 3.2.0.96 (64bit)
HANA is 1.00.12.23.....

Holger

That looks like a bug. I opened TMB-2230 so that we can fix it.
In the meanwhile you could try disabling "Perform automatic syntax checks" here:

Hi Dan,

same error

same error
image

on HANA Studio

Holger