PL/SQL (MOSC)

MOSC Banner

How to read a blob (binary file) from database ?

edited May 9, 2011 10:09AM in PL/SQL (MOSC) 2 commentsAnswered
 Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center