Long Raw to Text Format in Oracle

[Ritu1]

Hi,

I have an Oracle table with a column of long raw datatype. I want to see the data in this column so I can manipulate it. Can you please advice on some function/procedure to convert this to readable format?

SQL> desc EDI_DATA
Name Null? Type
-------------------------- ----- -------------
RELEASE_CHAR VARCHAR2(2)
EDI_DOC LONG RAW

Thanks,
Ritu

[amitpatel66]

Possible with the help of PLSQL

 
CREATE TABLE EMP1
(
  ID         NUMBER                             NOT NULL,
  NAME       VARCHAR2(100 BYTE)                 NOT NULL,
  NO         CHAR(1 BYTE),
  HIRE_DATE  DATE,
  DATA_TEXT  LONG RAW
)
 
declare
dat varchar2(100);
begin
select data_text into dat from emp1 where id=4;
dbms_output.put_line(dat);
end;
 
 

[Pilgrim333]

It depends on the size of the long raw.

Pilgrim.

[amitpatel66]

Yes it depends on the amount of data stored in a long raw. If it is large and cannot be hold by a varchar variable then you will need to fix that.