Subject Re: Hex string literal, blob not supported for conversion?
Author Dmitry Yemanov
31.08.2015 17:31, Martijn Tonies wrote:
>
> 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.


Dmitry