How to extract from LONG RAW data in Oracle.

[laconicamit]

HI!

I have a binary data stored in a LONG RAW column in an Oracle table. The Binary data contains .pdf document. Can anybody please help me to write a function/SP which extracts that Binary data back to pdf document or to a text file?

Any help would be highly appreciated.

Thanks in Advance!!!

[amitpatel66]

HI!

I have a binary data stored in a LONG RAW column in an Oracle table. The Binary data contains .pdf document. Can anybody please help me to write a function/SP which extracts that Binary data back to pdf document or to a text file?

Any help would be highly appreciated.

Thanks in Advance!!!

Make use of RAWTOCHAR to convert the RAW data to character type

[amitpatel66]

Make use of RAWTOCHAR to convert the RAW data to character type

Check below functions:

FUNCTION chartoraw(v_char varchar2) return long raw
is
rawdata long raw;
rawlen number;
hex varchar2(32760);
i number;
begin
rawlen := length(v_char);
i := 1;
while i <= rawlen
loop
hex := numtohex(ascii(substrb(v_char,i,1)));
rawdata := rawdata || HEXTORAW(hex);
i := i + 1;
end loop;
 
return rawdata;
end;
 
 
FUNCTION rawtochar(v_raw long raw) return varchar2
is
rawlen number;
hex varchar2(32760);
rawparam varchar2(32760);
i number;
begin
hex := rawtohex(v_raw);
rawlen := length(hex);
i := 1;
while i <= rawlen
loop
rawparam := rawparam||CHR(HEXTONUM(substrb(hex,i,2)));
i := i + 2;
end loop;
 
return rawparam;
end;
 
 

[laconicamit]

Check below functions:

FUNCTION chartoraw(v_char varchar2) return long raw
is
rawdata long raw;
rawlen number;
hex varchar2(32760);
i number;
begin
rawlen := length(v_char);
i := 1;
while i <= rawlen
loop
hex := numtohex(ascii(substrb(v_char,i,1)));
rawdata := rawdata || HEXTORAW(hex);
i := i + 1;
end loop;
 
return rawdata;
end;
 
 
FUNCTION rawtochar(v_raw long raw) return varchar2
is
rawlen number;
hex varchar2(32760);
rawparam varchar2(32760);
i number;
begin
hex := rawtohex(v_raw);
rawlen := length(hex);
i := 1;
while i <= rawlen
loop
rawparam := rawparam||CHR(HEXTONUM(substrb(hex,i,2)));
i := i + 2;
end loop;
 
return rawparam;
end;
 
 

Hi!
I hope you didn't understood me correctly. Let me explain you once more, I have actually loaded the binary data (.pdf file) to an Oracle 10g database table's LONG RAW column. Now, I want to extract that LONG RAW column containing (pdf file) and write another pdf file. Then I will compare the file which is generated now and the pdf file which I have loaded to verify my load.

So, for that I need a pl/sql function-SP. If not possible via Pl/Sql you experts can provide me a Java, .Net code to extract that pdf file.

(Currently this LONG RAW column stores pdf file but later on it can store other Binary data as well)

Thanks In Advance.!!

[amitpatel66]

Hi!
I hope you didn't understood me correctly. Let me explain you once more, I have actually loaded the binary data (.pdf file) to an Oracle 10g database table's LONG RAW column. Now, I want to extract that LONG RAW column containing (pdf file) and write another pdf file. Then I will compare the file which is generated now and the pdf file which I have loaded to verify my load.

So, for that I need a pl/sql function-SP. If not possible via Pl/Sql you experts can provide me a Java, .Net code to extract that pdf file.

(Currently this LONG RAW column stores pdf file but later on it can store other Binary data as well)

Thanks In Advance.!!

In order to create a PDF from oracle data, you can check here

What you could do is get the binary RAW data, convert it to char, then write it to new pdf using logic as shown in the above link

[laconicamit]

In order to create a PDF from oracle data, you can check here

What you could do is get the binary RAW data, convert it to char, then write it to new pdf using logic as shown in the above link

It dosen't required to answer everytime, atleast "NOT" if you haven't understood the question correctly.

What am I asking is A and you are replying me Z...

Thanks anyways!!!

[amitpatel66]

It dosen't required to answer everytime, atleast "NOT" if you haven't understood the question correctly.

What am I asking is A and you are replying me Z...

Thanks anyways!!!

We are here to provide different kind of solutions to a problem or a path way so that you could proceed further. Dont expect exact solutions every time. If you feel you are not getting satisfied answer, then you can google it out your self!!

[laconicamit]

We are here to provide different kind of solutions to a problem or a path way so that you could proceed further. Dont expect exact solutions every time. If you feel you are not getting satisfied answer, then you can google it out your self!!

That's what I am doing Mr. Patel.

I am simply looking for an answer that .. How we can extract the Binary Data which is stored in LONG RAW column of a Oracle table.

Now, if you will provide me the solution that how we can change the character based data to pdf..Then after sometime I will ask you .. How to get an image file extracted from a Binary stored data.

I am not questioning you knowledge and expertise. What i said was, an humble and polite request you not to hop into to provide the opening to solution. Please try to figure out what members are trying to ask and try to provide the balanced solution..

And we member post question and reply to answers because we know that these things we cannot found over google. We post only after doing that with proper problem and expecting a proper answer (which sombody other might have faced and solved)

Thanks

[debasisdas]

Hi laconicamit

If you know how to use Visual Basic 6.0

Try to use AppendChunk and GetChunk method of recordset object of ADO

for storing and retriving files from LONG RAW column in Oracle.

[laconicamit]

Hi laconicamit

If you know how to use Visual Basic 6.0

Try to use AppendChunk and GetChunk method of recordset object of ADO

for storing and retriving files from LONG RAW column in Oracle.

Thanks Sir,

Let me check and get back to you..

Many Thanks.. :)