This content has been marked as final. Show 2 replies
It looks like the content is loaded into the IMAGE column but your query is selecting from the THUMB column.
Thanks for the reply. I had a typo in earlier post.
Below is the correct pl/sql that i used to load image into the table.
Please let me know what might be causing the problem?
I am not sure if its a prob but just wanted to let you know that i ftp'ed the image from windows to unix machine. I have Oracle 10G database on Unix.
Thanks for your help.
-- application variables
ctx RAW(4000) := NULL;
INSERT INTO ImageTable VALUES (
-- Select the newly inserted row for update
SELECT thumb INTO Image FROM ImageTable
WHERE id = 1 for UPDATE;
UPDATE ImageTable SET thumb = Image WHERE id = 1;
-- Continue processing