Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert to number.

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
at RTF2PDF.runRTFto(RTF2PDF.java:629)
at RTF2PDF.runXDO(RTF2PDF.java:439)
at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert  to number.
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
... 15 more



总结得出： 一般是查出来的xml 是NULL 值，导致不能转换成number类型，可以在源生成以前转换字段类型！

评论

2 楼 xingkongcj 2010-09-20  

XML Publisher has extended a set of SQL and XSL functions for use in RTF
templates. The syntax for these extended functions is
<?xdofx:expression?>
for extended SQL functions or
<?xdoxslt:expression?>
for extended XSL functions.

1 楼 xingkongcj 2010-09-20  

<?for-each:current-group()?>
<?sort:PRICE;'ascending';data-type='text'?>
<?xdoxslt:set_variable($_XDOCTX,'v1',xdoxslt:get_variable($_XDOCTX,'v1') +xdoxslt:to_number(QUANTITY))?>   
<?xdoxslt:set_variable($_XDOCTX,'v3',xdoxslt:get_variable($_XDOCTX,'v3') +xdoxslt:to_number(QUANTITY))?>   
<?xdoxslt:set_variable($_XDOCTX,'v2',xdoxslt:get_variable($_XDOCTX,'v2') +xdoxslt:to_number(PRICE)*xdoxslt:to_number(QUANTITY))?>   
<?xdoxslt:set_variable($_XDOCTX,'v4',xdoxslt:get_variable($_XDOCTX,'v4') +xdoxslt:to_number(PRICE)*xdoxslt:to_number(QUANTITY))?>   
<?end for-each?>
<?xdoxslt:get_variable($_XDOCTX,'v1')?>
<?xdoxslt:get_variable($_XDOCTX,'v2')?>
<?end for-each-group?>
<?CLS?>
<?xdoxslt:get_variable($_XDOCTX,'v3')?>
<?xdoxslt:get_variable($_XDOCTX,'v4')?>
<?end for-each-group?>