I have to insert blob in oracle view. In ths case there is no opportunity to use this EMPTY_BLOB() with returning clause. Like this:
"Insert into table (a,b,c) values (a,b, EMPTY_BLOB()) RETURNING c into :photo"
Becouse RETURING doesnt work in views
I need a method to create empty blob before inserting data, but i dont know how to do it with PDO.
Thanks!
In PHP connected to ORA DB I have recently solved a problem with inserting of CLOB which should be treated the same way.
In my case it was enough to insert the data as characters while when binding I set the length of characters as length of bind. But You can try to use a function TO_BLOB(), that needs an input casted to a RAW:
INSERT INTO my_blob_table (my_blob_column) VALUES (TO_BLOB(UTL_RAW.CAST_TO_RAW('some binary data as string')))
or also a universal TO_LOB() should work (converts to CLOB or BLOB depending on source/target column):
INSERT INTO my_blob_table (my_blob_column) VALUES (TO_LOB('some binary data as string'))
EDIT: Using google I found these should work:
long column that we want to convert to clob/blob:create table t1 (id int, my_blob blob);
create table t2 (id int, my_long long);
insert into t2 values (1, rpad('*',4000,'*'));
insert into t1 select id, to_lob(my_long) from t2;
long raw column that we want to convert to blob:create table t1 (id int, my_blob blob);
create table t2 (id int, my_long_raw long raw);
insert into t2 values (1, rpad('*',4000,'*'));
insert into t1 select id, to_blob(my_long_raw) from t2;
LONG type of data then there should be no problem with casting of LONG to BLOB using TO_BLOB nor TO_LOB.LONG column into a BLOB column? LONG is kinda outdated... Or at least convert Your LONG to LONG RAW and then call TO_BLOB(your_long_raw_data). Cannot think of better way...to_lob and to_blob...