Skip to Content

SBO Hana version Shift+F2

Jul 07, 2017 at 11:07 AM


avatar image

this is the first time to create SHIFT+f2

in MS SQL is ok:

DECLARE @par AS NVARCHAR(200)SELECT TOP 0 @par = 'A' FROM OCRD T0 WHERE T0.Password = '[%0]'EXEC XGetHash '[%0]'

in Hana i have a

create PROCEDURE XGetHash(in id nvarchar(300))LANGUAGE SQLSCRIPTAScnt nvarchar(30) := 'Fuji3776';wynik nvarchar(30);BEGIN   wynik := CAST(CONCAT(:id, cnt) as nvarchar(300));   SELECT UCASE(TO_VARCHAR(HASH_MD5(to_binary(wynik)))) as  FROM DUMMY;END

and then in filed i have a SHIFT+F2:

par nvarchar;SELECT 'A' INTO par FROM OCRD T0 WHERE T0."Password" = '[%0]';CALL "XGetHash"('[%0]');

and i have an error:

please help me to solve a problem

bag-error.png (5.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers