Re: Insert picture into oracle
From: Steve Cooper <coos02_at_blackburn.ac.uk>
Date: 30 Dec 2003 15:32:38 -0800
Message-ID: <2cd89d54.0312301532.5caf2d12_at_posting.google.com>
Date: 30 Dec 2003 15:32:38 -0800
Message-ID: <2cd89d54.0312301532.5caf2d12_at_posting.google.com>
m004202002_at_yahoo.com (why) wrote in message news:<755f39b8.0312220339.265753ac_at_posting.google.com>...
> "Kysar Sharif" <kysar_at_totalise.co.uk> wrote in message news:<bs4olm$hus$1_at_sparta.btinternet.com>...
> > Use DBMS_LOB - server side package
>
> Thank you for replies .
> I use oracle 9i and devloper 6i .
> and windows os .
>
> if there is a picture in c:\mydocument\pic.jpg
> how I store that picture in oracle DBMS .
>
> what are the general ways ?
>
> Please help .
>
> Thank you.
Can't you just use read_image_file.
create db block with blob item and use read_image_file to get it from the filesystem into the block. then just commit. Received on Wed Dec 31 2003 - 00:32:38 CET