Re: Storing images in oracle
From: <dlm_at_hermes.dlogics.com>
Date: 15 Jan 93 19:24:54 CST
Message-ID: <1993Jan15.192454.1342_at_hermes.dlogics.com>
Date: 15 Jan 93 19:24:54 CST
Message-ID: <1993Jan15.192454.1342_at_hermes.dlogics.com>
neil_at_kynug.org writes:
> Version 6.0.30 of Oracle has a limit of 65,000+ characters for the long
> raw datatype.
>
while this is true, it cannot stop you from storing objects much larger
than 65K: just store objects of size N as a series of ceil(N/65K) rows.
tie them together with common primary keys and sequence numbers.
if you write in pro*C you will have no problem reconstructing the original object either on a file or in memory by fetching the rows in order within a loop.
-- Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450 dlm_at_dlogics.com Motto: Just show me the codeReceived on Sat Jan 16 1993 - 02:24:54 CET