blob can only work using procedure?

[alineri]

Hello everybody, I would like to confirm that, for working with images in Blob fields in oracle, so much to give a insert, update, and a select I need necessarily use a procedure?

There is no product oracle propria for blob fields?

that way if I have a table:

Code: Select all

CODIGO NUMBER
NOME    VARCHAR2
DESCRICAO VARCHAR2
FOTO BLOB

first I do an insert in other fields and after I run the procedure to include the image into blob field?

When you give a selexct will be the same thing, give a select in other fields to then run a procedure that retrieves this field?

a strong abarco all alineri

[Trevisolli]

Aline, OK?

Take a look here on the Forum, for DBMS_LOB, which is a package for manipulating LOBs.

qualquer thing, send it to us, okay?