1. Developing SOA Applications with Oracle SOA Suite
  2. XPath Extension Functions
  3. Database Functions
  4. lookup-table

lookup-table

This function returns a string based on the SQL query generated from the parameters.

The string is obtained by executing: 

SELECT outputColumn FROM table WHERE inputColumn = key

You execute it against the data source that can be either a JDBC connect string (jdbc:oracle:thin:username/password@host:port:sid) or a data source JNDI identifier. Only the Oracle thin driver is supported if the JDBC connect string is used.

Example:

oraext:lookup-table('employee','id','1234','last_name','jdbc:oracle:thin:xyz/xyz@localhost:1521:ORCL')

Signature:

oraext:lookup-table(table, inputColumn, key, outputColumn, data source)

Arguments:

  • table: The table from which to draw the data.

  • inputColumn: The column within the table.

  • key: The key value of the input column.

  • outputColumn: The column to output the data.

  • data source: The source of the data.

Property IDs:

  • namespace-uri: http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc

  • namespace-prefix: oraext