Maxim Demenko wrote:
> 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
You are correct unless the client is mapped to the server which is
certainly something I wouldn't recommend. Thanks for catching that.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 29 2007 - 10:19:23 CST
