In Teradata 17, I am trying to call their own
hash_md5 external function from my own SQL stored procedure:
replace procedure p() sql security creator begin declare l_hash varchar(32); set l_hash = hash_md5('abc'); end; call p();
Failed [3706 : 42000] P:Syntax error: expected something between '(' and the string 'abc'.
I can call this function successfully in plain SQL:
I tried to pass a parameter in, instead of a hardcoded literal, but it made no difference.