PL/SQL (MOSC)

MOSC Banner

How to convert string to binary (CLOB to BLOB) ?

edited May 11, 2011 1:23AM in PL/SQL (MOSC) 6 commentsAnswered
 Hi,

In my application, binaries files (matlab) are generated. These files are converted into text files and then datas are loaded in a database as CLOB.
Here is an example of CLOB datas :
0.001
123.9876
34.87

Now, we don't want to convert binaries files to text files anymore. So, we want to store the data as BLOB.
The datas in the binaries files are in double format.

But, we have to convert the current datas in the database from CLOB to BLOB.
We don't want to use the procedure DBMS_LOB.converttoblob because we obtain ASCII format datas. In the BLOB column, we want binary datas.

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