Function with blobs, how?

[Thomas Flemming]

Hi,

how do I write a function, which retunrs a specific byte out of a blob-field?
For example:

CREATE OR REPLACE FUNCTION MyBlob10( inValue blob) RETURNS byte
BEGIN
    RETURN inValue[10];
END

This always retunrs a syntax-error after inValue in line 3 when I SqlExecute() 
this.

Thanks,
Tom




-- 
/****************************************
**   Flemming Software Development CC
**   Thomas Flemming
**   PO Box 81244
**   Windhoek, Namibia
**   http://www.quovadis-gps.com
**   mail  tf at qvgps.com
**   +264 (0)81 3329923
**   +49  (0)6182 8492599
***************************************/