pears.BlobstoreFetch

CREATE FUNCTION "pears"."BlobstoreFetch"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "blobclass" CHAR(1),IN "blobid" CHAR(20) ) 
RETURNS long BINARY
BEGIN
  DECLARE "xpath" CHAR(250);
  DECLARE "dat" long BINARY;
  SELECT "externalfilepath","blob" INTO "xpath","dat" FROM "blobstore" WHERE "class" = "blobclass" AND "id" = "blobid";
  IF "dat" IS NULL AND "trim"("isnull"("xpath",'')) <> '' THEN
    SET "dat" = "xp_read_file"("BlobstoreFullPath"("xpath"))
  END IF;
  RETURN "dat"
END