BLOB

[swakoo]

hmmm.. newbie here..
i have a jpg file.
how is it possibe for me to write a stored procedure and insert it into a table field declared as blob.
thanks

 

[Marco Kalter]

There is nothing special about it:

create or replace procedure insert_picture(p_id number, p_pic in blob) is
begin
  insert into pictures
    (id, pic)
  values
    (p_id, p_pic);
end insert_picture;

It may be more difficult to pass the jpeg blob data to this stored procedure, but this depends on your application.