Viewing PDF stored in database with BLOB column datatype..

[RRomano]

Hi,
Anyone has a sample of stored procedure to view/retrieve a PDF files from database table with BLOB datatype column. Thanks for the big help..

 

[Marco Kalter]

When viewing BLOB's from within the Test Window (bind variables or result set fields) or SQL Window (result set fields), the Large Data Editor will be invoked. This allows you to view BLOB contents in several formats, but can also invoke an external viewer like the Acrobat Reader. See chapter 19 in the User's Guide for detailed information.