Upload images to database in batch
426455Jan 10 2005 — edited Jan 10 2005Hi all.
I am trying to create a procedure to upload some images in a batch job. It is on linux so I think it should be initiated as a shell script. The images should be stored in a blob column in a table called nafa.na_archive.
In addition to this, some more information should be uploaded to this table. Also, this information should be based on user input. Also, not only one file should be uploaded, but all files in a specific folder on the disk. So, my first thought is to call the shell script with the two "user specific input parameters", loop in the directory for all files and send one by one of the file names, as well as the two user specific parameters as input values to a procedure in the database. Now, I wonder, with the file name stored in a variable and two other table column values stored as a variable, I must do an table insert for these additional values, but how is the blob inserted into the database?
Best Regards
Kjell Ove