Firebird Server Version: WI-V2.5.0.26074 Firebird 2.5

CREATE DATABASE 'bdname' DEFAULT CHARACTER SET WIN1251;

create procedure test (p_in varchar(256))
returns (p_out varchar(256))
as
begin
  rdb$set_context('USER_SESSION', 'UNAME', :p_in);
  p_out = coalesce(rdb$get_context('USER_SESSION', 'UNAME'), current_user);
  suspend;
end

isql -u sysdba
execute procedure test('test')
--test

execute procedure test('ÔÅÓÔ') --ÎÅ ÌÁÔÉÎÉÃÁ

Invalid token
Mailformed string
At procedure TEST1 line 7 col 2

âÁÇÁ ÉÌÉ ËÁËÉÅ-ÔÏ ÚÁÍÏÒÏÞËÉ Ó ËÏÄÉÒÏ×ËÁÍÉ?

ëÓÔÁÔÉ, ÅÓÌÉ ÚÁÍÅÎÉÔØ ÎÁ
  p_out = coalesce(rdb$get_context('USER_SESSION', 'UNAME'),
rdb$get_context('SYSTEM', 'CURRENT_USER'));

ÔÏ ×ÓÅ ÎÏÒÍÁÌØÎÏ.




Ответить