How to read a blob (binary file) from database ?
I have a binary file that I want to load into a blob column of my database (10.2.0.4).
My datafile contains 10 numbers : 0.01,0.02,0.03,0.04 ....0.10.
But, If I tried to edit this file with a text editor, I obtain something like this :
{®Gáz„?{®Gáz”?¸…ëQ¸ž?{®Gáz¤?š™™™™™©?¸…ëQ¸®?ìQ¸…ë±?{®Gáz´?
×£p=
·?š™™™™™¹?
To load this file into the blob column, I use the following procedure :
PROCEDURE P_LOAD_FILE_MEASUREMENTS(p_cycle_id in NUMBER,
p_variable_id in NUMBER,
p_engine_id in NUMBER,
pv_file_name in VARCHAR2,
pv_err_num out VARCHAR2,
pv_err_mess out VARCHAR2)
is