How to use Extended SQL and XSL Functions

XML Publisher has extended a set of SQL and XSL functions for use in templates. The syntax for these extended functions is

<?xdofx:expression?>

for extended SQL functions or

<?xdoxslt:expression?>

for extended XSL functions.

Note: XLS PE unique syntax
Using XLS Processor Engine for Oracle® e-Business Suite you CAN mix xdofx and xdoxslt statements with XSL expressions in the same context.

For example, assume you had two elements, FULL_NAME and EMPLOYEE_NUMBER, that you wanted to concatenate into a 40-character field and right pad the field with the character "x".

You CAN use the following:

<?xdofx:rpad(concat(FULL_NAME,EMPLOYEE_NUMBER),40,'x')?>

because concat is an XSL expression. Also, you CAN use the following:

<?xdofx:rpad(FULL_NAME||EMPLOYEE_NUMBER),40,'x')?>

Certainly, you CAN also use the following:

<?concat(xdofx:rpad(FULL_NAME,40,'x'),xdofx:rpad(EMPLOYEE_NUMBER,10,'0'))?>

This example is displayed in the figure below (download the example):

Grau op Friday 06 June 2008 - 13:01:16