Re: Binary GIF into Oracle Database and out again

Well, yes. I didn't actually state it but what I meant was that ordinary mortals who are not C programmers and hardly know what OCI means (like me) have to do it like that.

I'll be more specific about that sort of thing in this newsgroup in future and humbly remember where I am. (Mind you, I still think that "anyone", as in "anyone can write an app" is stretching it a bit far).

This refers to these articles:
> 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.

Tony Scott
(asc_at_cix.compulink.co.uk) Received on Wed Feb 09 1994 - 23:50:12 CET