Why A User Gets "Missing IN Or OUT Parameter" Error Creating Non-standard Sql Data Model Using BI Publisher (Doc ID 1915759.1)

Last updated on JANUARY 03, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.7.x [Release 11.1]
Information in this document applies to any platform.

One is seeing the message:

BI Publisher "Missing IN or OUT parameter" error creating non-standard sql data model

The problem can be re-produced with the following steps:
1. Creating a non-sql data model to call a stored procedure before selecting data from a table in a BIP data model.
Using example found here http://docs.oracle.com/cd/E28280_01/bi.1111/e22258/whatsnew.htm#CHDFJJJI
2. In BI Publisher-> new data model-> data set-> new SQL
3. Select non-standard SQL option and enter this code (similar to example):

4. Go to data tab and press view - get error "XML failed to load"
5. Press Get Data Engine Log. See oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Solution

In this Document

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com . � Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use