This function looks up a cross-reference column for a value that corresponds to a value in a reference column.

Signature:

xref:lookupXRef(tableName,referenceColumnName,referenceValue,columnName,needAnException)

Arguments:

• xrefLocation: The cross-reference URI.

• xrefReferenceColumnName: The name of the reference column.

• xrefReferenceValue: The value corresponding to the reference column name.

• xrefColumnName: The name of the column to be looked up for the value.

• needAnException: When the value is set to true, an exception is thrown if the value is not found. Otherwise, an empty value is returned.

Property IDs:

• namespace-uri:http://www.oracle.com/XSL/Transform/java/oracle.tip.xref.xpath.XRefXPathFunctions

• namespace-prefix: xref

For more information, see About the xref:lookupXRef Function.