Forms 6i - loading a binary file into a BLOB
From: Macvl2000 <macvl2000_at_yahoo.it>
Date: 28 Dec 2001 11:57:50 -0800
Message-ID: <dfb206b6.0112281157.7a943e7d_at_posting.google.com>
I am developing a Forms 6i client/server application in a Win2k environment. Upon request by the user, the application must read a binary file
(say, a Word document or an Excel spreadsheet) stored in the filesystem of
the client PC and save it into a BLOB column of a database table.
Date: 28 Dec 2001 11:57:50 -0800
Message-ID: <dfb206b6.0112281157.7a943e7d_at_posting.google.com>
I am developing a Forms 6i client/server application in a Win2k environment. Upon request by the user, the application must read a binary file
(say, a Word document or an Excel spreadsheet) stored in the filesystem of
the client PC and save it into a BLOB column of a database table.
I tried to use ORA_FFI for loading the file but I found no way to return a buffer containing ASCII 0's into a PLSQL varchar2 variable, so this method does not seem useful.
The question is: what is the best way to load a file into a BLOB using Forms
(d2kutil, user exit, ....)?
Received on Fri Dec 28 2001 - 20:57:50 CET