Hello Dmitry, >> This works: >> >> CREATE TABLE BMP_BLOBS >> ( >> ID INTEGER NOT NULL, >> BMP BLOB SUB_TYPE 0 SEGMENT SIZE 80, >> "COMMENT" VARCHAR( 20) COLLATE ISO8859_1, >> CONSTRAINT PK_BMP_BLOBS PRIMARY KEY (ID) >> ); >> >> insert into BMP_BLOBS >> values (-1, X'101010', 'test') >> >> How is the declared function any different? > >UDFs were always quite limited.
Nevertheless, the parameter is BLOB. Why is one blob conversion supported, but an other, that looks the same to the user, fails? This is counter intuitive. (and yes, I do read between the lines you don't feel compelled to change it) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!
