pears.BlobstoreFetch

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."BlobstoreFetch" IS 
{CREATE FUNCTION 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
}