HOW CAN I TRANSFORM AND RUN THIS QUERY IN 8i?
Hi all,
this query run in Oracle 9i but not in oracle 8i:
select
to_lob(dbms_lob.substr(data,dbms_lob.getlength(data)-dbms_lob.instr(data,'3F3E')-1,dbms_lob.instr(data,'3F3E')+4)) as stream_data,
filename as stream_name,
substr(filename,instr(filename,'.')+1,length(filename)) as stream_type,
dbms_lob.getlength(to_lob(dbms_lob.substr(data,dbms_lob.getlength(data)-dbms_lob.instr(data,'3F3E')-1,dbms_lob.instr(data,'3F3E')+2))) as content_length,
progr as stream_progr
from
vm_mmsrelay_mmcontent
where id_msg like '%1071760263441%'
and CONTENTTYPE='application/smil'
SQL> desc vm_mmsrelay_mmcontent
Name Null? Type
----------------------------------------- -------- ----------------------------
DATA BLOB
FILENAME VARCHAR2(50)
CONTENTTYPE VARCHAR2(50)
ID_MSG NOT NULL VARCHAR2(150)
PROGR NOT NULL NUMBER(38)
Thanks in advance