====== pears.BlobstoreFetch ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
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
</code>