Inserting BLOBs from files with the filename stored in another column

From: <>
Date: Thu, 25 Oct 2012 23:18:14 -0700 (PDT)
Message-ID: <>

Hello all,

we need to migrate article images into an existing table; the name of each article's image file is stored in a column of table Articles, basically:


IMG_FILENAME [varchar2(100)] | IMAGE [blob]

I found nothing helpful so far on the web. Is there a simple way to do this in PL/SQL or do I have to use an external script? Any help would be greatly appreciated.

Regards, Leo Received on Fri Oct 26 2012 - 08:18:14 CEST

Original text of this message