Re: Binary GIF into Oracle Database and out again

In <CKvpHz.219_at_cix.compulink.co.uk>, asc_at_cix.compulink.co.uk ("Tony Scott") writes:
>As I understand it, in order to get pictures into an Oracle RDBMS you
>have to use an Import function in one of the tools.
>
>Tony Scott
>(via OLR)

Not true. Using v7 OCI, anyone can write an app that inserts long binary data into the database. Just use the LONG RAW datatype [24] when binding in OCI, and you'll be fine. On the Windows platform, you'll need to use the LONG VARRAW type [95]. The only restriction is that in order to insert a big picture, you'll have to be able to malloc() space for it in 1 big hunk. There is no piece-wise insert, as there is for piece-wise fetching [via oflng()].

Dave Colello
dcolello_at_oracle.com

The views expressed here are my own and not my employer's. Received on Wed Feb 09 1994 - 18:53:08 CET