Stimulsoft Business Intelligence System | Forum

Hello, I have a Stored Procedure and I wanted to use it, followed the tutorial from the video link on youtube:

https://www.youtube.com/watch?v=lhyyHr0AvrY

However, when I place the Execute command, the Report returns an ORA error - 00900: invalid SQL statement, as shown in the attached image, so I would like to know the correct way to pass the parameters to be able to return my data on screen, if Can you clarify this doubt, thank you very much.

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

Hi, any news on the question?

Hello,

We couldn't reproduce the issue.
Please send us scripts for creating your tables, procedures, and report for analysis.

Thank you.

Hello Lech, I am sending in the attachment the SQL script of the Procedure and the Table of the database used as well as the report that I am carrying out the tests.

It is important to note that I can insert the data in the table through the Report Designer only when I select the option to retrieve columns according to the attached image, when I go to the test tabs nothing happens, I continue in the tests and wait for the return.

Hello,

We do not recommend using procedures that make any modifications in the database in reports.

Thank you.

Hi Lech, thank you very much for the information.

Hello,

You are welcome.