How does a Store Procedure work in Report Manager?

Stimulsoft Reports.JAVA discussion
Post Reply
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

How does a Store Procedure work in Report Manager?

Post by Manuel Costa »

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.
Attachments
ssss.png
ssss.png (56.45 KiB) Viewed 2024 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: How does a Store Procedure work in Report Manager?

Post by Lech Kulikowski »

Hello,

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

Thank you.
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Re: How does a Store Procedure work in Report Manager?

Post by Manuel Costa »

Hi, any news on the question?
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: How does a Store Procedure work in Report Manager?

Post by Lech Kulikowski »

Hello,

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

Thank you.
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Re: How does a Store Procedure work in Report Manager?

Post by Manuel Costa »

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.
Attachments
StoredProcedure_Report.7z
(3.07 KiB) Downloaded 132 times
1.png
1.png (37.42 KiB) Viewed 1740 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: How does a Store Procedure work in Report Manager?

Post by Lech Kulikowski »

Hello,

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

Thank you.
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Re: How does a Store Procedure work in Report Manager?

Post by Manuel Costa »

Hi Lech, thank you very much for the information.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: How does a Store Procedure work in Report Manager?

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply