Re: loading tables from blobs

Dan Cardinal wrote:

> Hi All,
>
> We have an oracle application where the user uploads text files to the
> system and later loads them into Oracle tables. The way we do it now
> is the text file is uploaded into a blob field. When the user is ready
> to load the actual table we dump the blob to disk and then use sqlldr
> to populate the destination table.
>
> Does anyone know if you can load a table directly from a blob field? I
> know it sounds a bit strange but I thought I'd ask because I'd like to
> handle this process without having to spin out to the OS.
>
> Thanks,
> --Dan

Look at the DBMS_LOB package. All the tools you need are there.

Daniel Morgan Received on Wed May 22 2002 - 15:29:16 CDT