Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!

sql Function Error

Avatar

Level 4

Hi Geeks,
I've been getting this error while executing this script in configuration->sql scripts.

create or replace function EncryptStringValue(sTringe varchar(255)) returns varchar(512) as '

declare

qryvalue varchar(150);

begin

select Crypt('fv', gen_salt('bf',8)) into qryvalue;

return qryvalue;

end;

' language plpgsql

;

The error im getting.

1724535_pastedImage_0.png

However this was working perfect when i tried in workflow.

Regards

0 Replies