input and output parameters for stored procedures

[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.]

Hello,

Can you please send us a sample data for analysis.

Thank you.

[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]

Hello.

Sorry, we need more time to answer your question.

Thank you.

[Alex K.]

Hello,

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

Thank you.