Re: storing graphics in oracle

In article <326D05BB.1D85_at_intelsat.int>, Rohit Saran <rohit.saran_at_intelsat.int> wrote:
>If one stores a bit-mapped graphics in Oracle, how does one retrieve
>it.. Can it be done using SQL or some other techniques have to be used.
>Any pointers will be appreciated.
>
>Thanks/Rohit...

Hi,

Be aware that PL/SQL allows a maximum 32K to be read for a LONG column. It gives errors when attempting to read LONG columns containing more data than this.

Pro*C can be used to insert and select from LONG columns however I think it must be done as one block. It would be really nice if you could read the LONG column in chunks (like reading a file).

Regards

John

Parallax Solutions Ltd.   Tel.: 01203 514522
Stonecourt,               Fax.: 01203 514401
Siskin Drive,             Web : http://www.parallax.co.uk/~johne
Coventry CV3 4FJ          Mail: johne_at_parallax.co.uk
________________________________________________________________
       Kaizen - Japanese, Lit: Never ending improvement
________________________________________________________________