Subject Passing a BLOB to a Stored Procedure in FIBPlus
Author Myles Wakeham
I have a Picture (Delphi Tpicture object) that I am trying to save in
Firebird 1.5. I use stored procedures for all calls to the database. I
have created a stored procedure that is called as follows:

SELECT * from PHOTO_SAVE_PRC(:PHOTO_ID, :PHOTO_IMAGE_BLOB);

I'm not exactly sure of two things:

1. What BLOB sub type should I use when storing Delphi Tpicture objects to
the database
2. What is the convention for saving & loading through a Stored Procedure
to Delphi? I'm using FIBPlus to communicate with Firebird. Note that this
is through a stored procedure, and not through any Data Aware components.

All help greatly appreciated.

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org