Hi

There was this developer in our company who wrote some perl program to convert jpeg files into hexadecimal files then using utl_file.get_line concatenate line by line and store as a raw variable and store as BLOB (using dbms_lob.write) in the database. It stinks but I am not allowed to change the whole process, the perl program is untouchble.

So my question is, is there a way to convert in a more efficient way a hex file into binary/raw format instead of concatenating line after line...?

Hi

If a variable is of type RAW and it's value is increased inside a loop is there anyway to reset it to zero after X loop iterations?

declare
v_raw raw(4000);
begin
for i in 0 .. 255 loop
v_raw := v_raw || utl_raw.cast_to_raw(chr(i));
-- equivalent expression without || operator
-- v_raw := utl_raw.concat(v_raw, utl_raw.cast_to_raw(chr(i)));
end loop;
for i in 1 .. utl_raw.length(v_raw) loop
dbms_output.put_line('raw(' || i || ')=[' ||
utl_raw.substr(v_raw, i, 1) || ']');
end loop;
end;
/
raw(1)=[00]
raw(2)=[01]
raw(3)=[02]
...
raw(254)=[FD]
raw(255)=[FE]
raw(256)=[FF]

This was somewhat helpful. It gave me some idea.
What I want to do is how I can save my file in .txt
and then covert my string data-characters and numbers
to hexidecimal. I can't seem to find a pl/sql script that
does it or what I need to write this script.

Any guidance would be helpful.

Hi Tom,

I have a table which store a binary file content(ms word doc file ) in a blob column. The data is inserted by using LOADFROMFILE of dbms_lob.

I am reading the blob in chunks of 57 using dbms_lob.substr which return the raw data. then i writes it to a text file hex. I use the utl_file.put_line to write file. when a raw data is assign to varchar2 variable it automatically get converted to hex. Am I right? So my text file is writen in hex. Pl correct me if worng.

Now i run a utilities available on internet hex2bin.exe and bin2hex.exe to perform conversion. these utility works fine when i convert a doc file to hex using bin2hex.exe and then again hex2bin.exe i get the same back. But does not work well with the file created by using oracle UTL_FILE. and does not create the binary file (doc file).

When i load the same doc file to database and write a hex file using utl_file and compare the hex file create by utl_file and bin2hex.exe utility. They are different.

Why the 2 file are differernt Does the automatic conversion from raw to varchar of utl_file generate different HEX data.

I am not able tounderstand this behaviour.

Actually my requirment is to display the data ie file store in the database on client FORM6i. The only way suggested by oracle metalink, is read from database write a text file(in hex) at client using text_io then run a utility to convert it to binary file back at client so that way your file is transfer from database to client. then you can open it on client using host cammand..

Any kind of help or suggestions will be higly appreciated.

Thanks,

Reagrds

Vikas Sharma

Hi Tom,

Thanks,

Regards

Vikas Sharma

Tom,

Could you let mw know how find the NOT value of a HEXADECIMAL value in SQL Query ?

Thanks and regards,
Ram

I wanted to find the NOT of HEXADECIMAL value "AAA"
The NOT for Hexadecimal value "AAA" is "FFFFF555".
I need to achieve the same in a SQL Query.

  1  select to_char(4294967295-to_number('AAA','XXXXXXXX'),'fmXXXXXXXX')
  2*       from dual
ops$tkyte@ORA10G> /
 
TO_CHAR(4
---------
FFFFF555
 

Excellent Tom !

Thank you very much !

Best regards,
Ram.