Hi,
We are trying to move from JDeveloper 11.1.1.7 to 12.1.3. We have developed a number of xsl maps in 11.1.1.7 which use the Oracle Extention function oraext:query-database (where the oraext namespace is xmlns:oraext="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"). This works in JDeveloper 11.1.1.7 when unit testing the map where the call in the map looks like this:
<xsl:value-of select="oraext:query-database(concat("select GetMapCodeList('param1', 'param2', 'param3') fvalue from dual"),false(),false(),"jdbc:oracle:thin:dbuser/dbpassword@dbhost:1521:dbservicename")"/>
In the select statement above is "select GetMapCodeList" which is a function defined in the database that takes 3 parameters. This works nicely for us in 11.1.1.7. We're new to 12.1.3 and we're getting an error testing the XSLT map in JDeveloper. The error is
file:/[file path]/[file name].xsl: XML-22044: (Error) Extension function error: Error invoking 'queryDatabase':'java.lang.NoClassDefFoundError: oracle/jdbc/OracleConnection'.
It looks like it can't find the ojdbc6.jar file, but I don't see where that should be added.
Edit:
OK, I've realized that the Oracle XPath extension functions are not appearing in my XSLT Map Editor component pallet. I also see that when I edit the xpath expression the oraext:query-database call is highlighted by JDev as invalid. I believe my problem is with the XPath extension functions not being loaded.
Thanks in advance.
Steve