Oracle Sql Developer“字面量太长”错误

您将需要使用CLOB作为XMLTYPE（）的输入，而不是VARCHAR。

使用

dbms_lob.loadclobfromfile

DECLARE   xmlClob CLOB;BEGINWITH openedXml AS (  SELECt extractvalue(column_value, '/theRow/First') FIRST,         extractvalue(column_value, '/theRow/Last') LAST,         to_number(extractvalue(column_value, '/theRow/Age')) Age    FROM TABLE(XMLSequence(XMLTYPE(xmlClob).extract('/theRange/theRow'))))SELECt *FROM openedxmlWHERe age BETWEEN 30 AND 35;END;