![]() I'm trying to read an xml file (log.xml on 11.2.0.4) using the following lines : declare c clob b bfile := bfilename('ALERT1','log.xml') x NUMBER := 0 p_src_offset NUMBER :=1 p_dest_offset NUMBER :=1 p_lang_context NUMBER:=DBMS_LOB.DEFAULT_LANG_CTX p_Warning NUMBER :=0 begin dbms_lob.open(b,dbms_lob.file_readonly) dbms_lob.createtemporary(c,true) dbms_lob.loadClobFromFile(dest_lob => c,src_bfile => b,amount => dbms_lob.getlength(b),dest_offset => p_dest_offset,src_offset => p_src_offset,bfile_csid => DBMS_LOB.DEFAULT_CSID,lang_context => p_lang_context,warning => p_Warning) dbms_lob.close(b) c:=''||c||'' FOR cur_rec IN ( select tt.* from XMLTABLE( '//msg[ passing XMLTYPE(c) columns "TEXT" VARCHAR2(300) path 'txt', "TIME" VARCHAR2(19) PATH ' "HOST_ID" VARCHAR2(14) PATH ' "MODULE" VARCHAR2(14) PATH ' ) tt)loop. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |