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