BI Publisher (MOSC)

MOSC Banner

How to use lexical parameter in XML Publisher report? Ending up with errors..

edited Apr 6, 2016 12:03PM in BI Publisher (MOSC) 5 commentsAnswered ✓

Hello All,

Actually there is a requirement to pass multiple values (Separated by comma or any other delimiter) to single parameter in an XML Publisher report.

So i am doing it using lexical parameter.I am getting below errors;

Calling XDO Data Engine...

java.lang.NullPointerException

and

Calling XDO Data Engine...

--SQLException

java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator.

Please see my package;

CREATE OR REPLACE PACKAGE APPS.where_clause_pkg

IS

v_customer_type_where_clause VARCHAR2(4000);

FUNCTION customer_type_where_clause( p_customer_type IN varchar2)

RETURN BOOLEAN;

END where_clause_pkg;

/

CREATE OR REPLACE PACKAGE BODY APPS.where_clause_pkg

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center