Re: Insert picture into oracle

why (m004202002_at_yahoo.com) wrote:
: "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 ?

You create the form with the ole field as described by another person, and setup whatever you need to be able to use the form as a "real" but simple application. (i.e define the table with the LOB field, etc.)

Now run the form (and login to the database etc).

For comparison, for most fields, you type in the desired data and press one of the form function keys and the data is saved into the database.

For the OLE field, the field provides something like a file selection box, or perhaps you drag the file's icon into the field, or it's something equally simple. (Well I forget the details actually, but the technique seems pretty obvious when you're using it).

In anycase, you then press the same function key as before to save the form's data and VOILA! the file contents are in the database.

Later, when you display the data in the form, then the form has some pretty way to show there's a picture, and if you double click the field (or something like that) then some kind of application opens to display the entire picture.

As you can tell, I haven't used this much, but the point is that if you define the OLE field and LOB column and have the form correctly using the table then you don't really _do_ anything to save the file into the database. You simply interact with the form and it all just works. Received on Mon Dec 22 2003 - 21:27:35 CET