create table gis.test2 (
resid varchar(10) UNICODE
)
//
create function GIS.ret_test
returns varchar AS
VAR
f varchar(10);
begin
try
select resid into :f from gis.test2;
return f;
CATCH
STOP(-20011, 'My custom message');
end;
//
create table temp.test (
resid varchar(10) UNICODE
)
//
insert into temp.test values (null)
//
insert into temp.test values ('1000')
//
select resid,GIS.ret_test() from temp.test
General error;-20011 System error: Otherwise unknown errorcode
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
