input and output parameters for stored procedures

Stimulsoft Reports.NET discussion
Post Reply
Jozef Balga
Posts: 56
Joined: Fri May 27, 2011 8:33 am
Location: Bratislava, Slovakia

input and output parameters for stored procedures

Post by Jozef Balga »

Hi!

I need to execute a stored procedure which has multiple number of input and output parameters. I would like to store the output parameters to report variables and display them on the report. How can I construct the SQL query which executes the stored procedure with the given parameters?
Thanks for the response.

Jozef
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

input and output parameters for stored procedures

Post by Alex K. »

Hello,

Can you please send us a sample data for analysis.

Thank you.
Jozef Balga
Posts: 56
Joined: Fri May 27, 2011 8:33 am
Location: Bratislava, Slovakia

input and output parameters for stored procedures

Post by Jozef Balga »

I am not sure a sample data would clarify my problem.
I need to call stored procedure using an Oracle ODP.Net database connection. A simple procedure looks like this

Code: Select all

create or replace
PROCEDURE PROCEDURE_TMP(in_param1 IN integer, in_param2 IN integer, out_param1 OUT integer, out_param2 OUT integer)
AS
BEGIN
  out_param1 := in_param1 + 1;
  out_param2 := in_param2 + 1;
END;
I would like to call the stored procedure with input parameters and display the output parameters on the report. These input and output parameters are defined by report variables. I am stuck at the beginning of the data source creation process, I am unable to execute the SQL query
execute PROCEDURE_TMP
it always returns ORA-00900: invalid SQL statement
even if I redefine the procedure with no parameters, the result is the same.
So I need a little help, how to call the stored procedures in general with input and output parameters.

And a few a little bit off-topic questions at the end:
1. Is there any way to catch the SQL query sent by Stimulsoft to the database server?
2. Could You extend the tutorial videos with a stored procedure call with parameters? Or a sample project - with the stored procedure PL/SQL code - would be a great help too.

Thank you for your answer.

Jozef
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

input and output parameters for stored procedures

Post by HighAley »

Hello.

Sorry, we need more time to answer your question.

Thank you.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

input and output parameters for stored procedures

Post by Alex K. »

Hello,

Unfortunately, on current moment, output parameters is not supported in our product.

Thank you.
Post Reply