oracle的sql字符串文字过长,Oracle Sql Developer“字符串文字太长”错误

我想在Oracle sql Developer中针对Oracle 10g服务器运行以下sql：

WITH 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('

BobSmith30

SueJones34

...

...

...

TomAnderson39

AliGrady45

').extract('/theRange/theRow')))

)

SELECT *

FROM openedxml

WHERE age BETWEEN 30 AND 35;

当我尝试运行它时,我收到以下错误：

Error at Command Line:1 Column:0 Error report: sql Error: ORA-01704: string literal too long

01704. 00000 - "string literal too long"

*Cause: The string literal is longer than 4000 characters.

*Action: Use a string literal of at most 4000 characters.

Longer values may only be entered using bind variables.

我的字符串偶尔会超过4000个字符.关于如何解决这个问题的任何想法？