You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
execute block as
declare v_stt varchar(255);
declare v_blob_a blob = 'qwertyuioplkjhgfdsazxcvbnm';
declare v_blob_b blob = '1234567890asdfghjklmnbvcxz';
begin
v_stt = 'update tb set b1 = case when id in (1,2) then ? else ? end';
execute statement ( v_stt ) ( v_blob_a, v_blob_b );
end
description: execute block as
declare v_stt varchar(255);
declare v_blob_a blob = 'qwertyuioplkjhgfdsazxcvbnm';
declare v_blob_b blob = '1234567890asdfghjklmnbvcxz';
begin
v_stt = 'update tb set b1 = case when id in (1,2) then ? else ? end';
execute statement ( v_stt ) ( v_blob_a, v_blob_b );
end
PS. 2 admin(s): please remove my post with timestamp 22/Apr/15 06:45 AM from CORE4752 because it is irrelevant to that.
=>
execute block as
declare v_stt varchar(255);
declare v_blob_a blob = 'qwertyuioplkjhgfdsazxcvbnm';
declare v_blob_b blob = '1234567890asdfghjklmnbvcxz';
begin
v_stt = 'update tb set b1 = case when id in (1,2) then ? else ? end';
execute statement ( v_stt ) ( v_blob_a, v_blob_b );
end
Submitted by: @pavel-zotov
execute block as
declare v_stt varchar(255);
declare v_blob_a blob = 'qwertyuioplkjhgfdsazxcvbnm';
declare v_blob_b blob = '1234567890asdfghjklmnbvcxz';
begin
v_stt = 'update tb set b1 = case when id in (1,2) then ? else ? end';
execute statement ( v_stt ) ( v_blob_a, v_blob_b );
end
-- on WI-V2.5.5.26865 produres error:
Statement failed, SQLSTATE = HY004
Dynamic SQL Error
-SQL error code = -804
-Data type unknown
No such error on WI-T3.0.0.31805.
The text was updated successfully, but these errors were encountered: