SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cracking a BLOB

532632Feb 5 2008 — edited Feb 6 2008

Hi,

I have a table with one of its fields as a BLOB.
I am using the function below to crack it in string format:

 FUNCTION z_fn_get_segments(plr_curvevalue LONG RAW,
pv_curvename VARCHAR2)
RETURN VARCHAR2
IS
LANGUAGE JAVA
NAME 'SiBlobStats.GetInfoString(byte[],java.lang.String) return java.lang.String';

Here plr_curvevalue is a BLOB type and the function returns the converted string. This function is using a Java class.

Is there any oracle in-built function which can acheive the same?
Or can I write a procedure\function myself to achieve this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2008

Added on Feb 5 2008

10 comments

739 views