query-database
This function returns a node set by executing the SQL query against the specified database.
Signature:
oraext:query-database(sqlquery as string, rowset as boolean, row as boolean, data source as string)
Arguments:
-
sqlquery: The SQL query to perform. -
rowset: Indicates if the rows should be enclosed in an element. -
row: Indicates if each row should be enclosed in an element. -
data source: Either a JDBC connect string (jdbc:oracle:thin:username/password@host:port:sid) or a JNDI name for the database.
Property IDs:
-
namespace-uri:http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc -
namespace-prefix:oraext