Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to insert file from client side to blob via SqlPlus ?
On Nov 28, 2:05 pm, "Maija-Leena" <kangasm..._at_netti.fi> wrote:
> Hi,
> what is the simplest way of inserting a file from a client to a blob column
> using SqlPlus ?
>
> Regards,
>
> Maija-Leena
a little Q&D:
call !sqlldr from sqlplus, see e.g. http://www.orafaq.com/faqloadr.htm#LOBS
for a sample. I would not recommend this for production code that is
exposed to end-users.
A proper way would perhaps be through a browser app using a http
upload to the appserver (APEX?), but have never built such a thing.
Another option could be to put the file on the server using a shared
disk (windows share or mapped drive or samba share in case of a unix
server). Then the client calls a stored procedure that accesses the
file through a directory.
Also not too elegant in my opinion.
Perhaps Oracle Forms has some options for client side file operations.
Not sure.
Good luck, regards, Erik Ykema
Regards,
Erik
Received on Fri Nov 30 2007 - 11:37:49 CST