创建XML DB时出的问题!

Question

把你的L1.xml贴上来啊。是他的语法不对的。

Answer 1

<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XML Spy v4.4 U (http://www.xmlspy.com) by Fanyl -->
<recorders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="G:\project\XMLDB\Example.xsd">
<recorder Accession_No="0100000001">
<Pub_Name>Food and Drug Administration Releasable 510(k)</Pub_Name>
<_510K_Number>K002142</_510K_Number>
<Applicant>EMT-RX</Applicant>
<Name>ROBERT J BARD</Name>
<Address>
<street1>9400 RANSDELL RD., SUITE 10</street1>
<street2/>
<city>RALEIGH</city>
<state>NC</state>
<zip>27603</zip>
</Address>
<DeviceName>SALINE IV FLUSH SYRINGE</DeviceName>
<DateReceived>2000-07-17</DateReceived>
<DecisionDate>2002-02-28</DecisionDate>
<Decision>Substantially Equivalent(SE)</Decision>
<Review-Advisory>General Hospital (HO)</Review-Advisory>
<Product-Code>FOZ</Product-Code>
<Letter>SUMMARY</Letter>
<Advisory-Comm>General Hospital (HO)</Advisory-Comm>
<Status>Summary only</Status>
<Type>TRADITIONAL</Type>
<Third-Party-Review>No</Third-Party-Review>
<Audit-2>#No#data#in#$10#ZIP#</Audit-2>
<Load-Date>2003-02-10</Load-Date>
<Source>#FDA#</Source>
<Report-No>FDA510</Report-No>
<Content>#medical#</Content>
</recorder>
</recorders>

Answer 2

http://www.itpub.net/showthread.php?s=&threadid=49812(转)
function getDocument(filename varchar2,charset varchar2 default 'ZHS16GBK') return 
clob deterministic authid current_user is 
charContent CLOB; 
targetFile BFILE; 
dest_offset number := 1; 
src_offset number := 1; 
lang_context number := 0; 
conv_warning number := 0; 
begin 
targetFile := bfilename('XMLDIR',filename); 
DBMS_LOB.createTemporary(charContent,true,DBMS_LOB.SESSION); 
DBMS_LOB.fileOpen(targetFile,DBMS_LOB.file_readonly); 
DBMS_LOB.loadClobFromFile( 
charContent, 
targetFile, 
DBMS_LOB.getLength(targetFile), 
dest_offset, 
src_offset, 
nls_charset_id(charset), 
lang_context, 
conv_warning 
); 
DBMS_LOB.fileClose(targetFile); 
return charContent; 
end;