How does a Store Procedure work in Report Manager?
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
How does a Store Procedure work in Report Manager?
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.
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 (56.45 KiB) Viewed 2263 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How does a Store Procedure work in Report Manager?
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Re: How does a Store Procedure work in Report Manager?
Hi, any news on the question?
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How does a Store Procedure work in Report Manager?
Hello,
We couldn't reproduce the issue.
Please send us scripts for creating your tables, procedures, and report for analysis.
Thank you.
We couldn't reproduce the issue.
Please send us scripts for creating your tables, procedures, and report for analysis.
Thank you.
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Re: How does a Store Procedure work in Report Manager?
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.
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 144 times
-
- 1.png (37.42 KiB) Viewed 1979 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How does a Store Procedure work in Report Manager?
Hello,
We do not recommend using procedures that make any modifications in the database in reports.
Thank you.
We do not recommend using procedures that make any modifications in the database in reports.
Thank you.
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Re: How does a Store Procedure work in Report Manager?
Hi Lech, thank you very much for the information.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How does a Store Procedure work in Report Manager?
Hello,
You are welcome.
You are welcome.