onsh76
Junior Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Manlike
Abstraktnyi otvet takov: tvoya kartinka (16x16) dolzhna bytx predstavlena v vide bytestream, i ssylka na resurs bytestreama dolzhna bytx peredana in VALUES clause.
Odnim SQL tut ne oboidesh'sya - vybirai, ili sozdavai svoi image v vide streama cherez PL/SQL ili cherez kakoi-libo API, naprimer JDBC. Primer vnizu dlya PL/SQL:
declare
theimage long raw;
f utl_file.file_type;
begin
f := utl_file.fopen('/folder/on/database/server','myimage.jpg','r',32767);
utl_file.get_raw(f,theimage);
INSERT INTO metrologysymbol (id_metrologysymbol, n_metrologysymbol, p_metrologysymbol)
VALUES (s_metrologysymbol.NEXTVAL, 'BLAHBLAHBLAH', theimage);
commit;
end;
=======================================================
Kstati, esli estx vozmoznostx predstavitx images kak BLOB vmesto RAW LONG, predpochtitelxno ispolxzovatx BLOB, vot ssylka ot Oracle 9i (ne uveren kakayu versiyu Oracle ty ispol'zueshx):
Note:
Oracle Corporation strongly recommends that you convert LONG columns to LOB columns as soon as possible. Creation of new LONG columns is scheduled for desupport.
LOB columns are subject to far fewer restrictions than LONG columns. Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases.
|
