loading tables from blobs

From: Dan Cardinal <dcardina_at_zsassociates.com>
Date: 22 May 2002 11:50:03 -0700
Message-ID: <f8b7a7f9.0205221050.1b894fee@posting.google.com>

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 Received on Wed May 22 2002 - 13:50:03 CDT