Re: How to insert file from client side to blob via SqlPlus ?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 28 Nov 2007 23:19:12 +0100
Message-ID: <474DE960.50307@gmail.com>

DA Morgan schrieb:

> Maija-Leena wrote:

>> Hi,
>> what is the simplest way of inserting a file from a client to a blob
>> column
>> using SqlPlus ?
>>
>> Regards,
>>
>> Maija-Leena

> 
> Look at the dbms_lob built-in package
> http://www.psoug.org/reference/dbms_lob.html

Don't think dbms_lob can handle files on the client. One of possibilities on the recent oracle version which don't involve coding in third party language could be builtin XMLDB (iirc - no additional license cost) - file can be transferred into repository by means of wide used protocols - webdav or ftp.

Best regards

Maxim Received on Wed Nov 28 2007 - 16:19:12 CST