This content has been marked as final. Show 3 replies
if you want use dynamic condition then see Lexical References in Oracle XML Publisher Administration and Developer's Guide (http://download.oracle.com/docs/cd/B40089_06/current/acrobat/120xdoig.pdf)
Create a lexical reference using the following syntax:¶metername
Define the lexical parameters as follows:
• Before creating your query, define a parameter in the PL/SQL default package for each lexical reference in the query. The data engine uses these values to replace the lexical parameters.
• Create your query containing lexical references.
post oebs questions to EBS General Discussion General EBS Discussion
Set the initial value of parameter as 1=1 than try.
That fixed the issue. Thanks for your help.