Inserting BLOBs from files with the filename stored in another column

From: <leichtenfels_at_gmail.com>
Date: Thu, 25 Oct 2012 23:18:14 -0700 (PDT)
Message-ID: <e5eb5615-b184-46f9-9292-ed851aa90d9e_at_googlegroups.com>



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:

ARTICLES



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