How to call a stored procedure from Reporting Dashboard - ORACLE

[Inger_Granli]

Hi

We are trying to configure a data provider which calls a PL/SQL procedure.    The procedure has the following signature:

create or replace PROCEDURE ReportTest

(

fra Date,

til Date,

C1 IN OUT SYS_REFCURSOR

)

The procedure works fine when testing it in SQL Developer. 

We get the following error when configuring the dataprovider:

'Only dynamic parameters can be used in conjunction with stored procedures. The text <....> should be replaced with a dynamic paramter'

It is hard to find any relevant documentation for this problem.   Can anyone please help with information on what is the correct way to handle this in the data provider? An example would be highly appreciated.

Kind regards,

Inger

[aboucher]

I added the Database Technical Community group here for their insight.

[Inger_Granli]

Great, thanks a lot.  🙂

Regards,

Inger

[aboucher]

Hi @Inger Magny Granli,

Here is some information from a previous case regarding your question:

This appears to be an issue with the dynamic parameters. This will work if dynamic parameters are excluded. If you want to use dynamic parameters to adjust the behavior of the results, the current workaround is to create the Data Provider using SQL instead of the stored procedure.

Thanks!

~Alan

[Inger_Granli]

Hi Alan,

okei, then I assume dynamic parameters only work with SQLServer stored procedures, not with Oracle?

Thank u for the answer on this.

Regards,

Inger