Page 1 of 1
input and output parameters for stored procedures
Posted: Mon Nov 07, 2011 6:40 am
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
input and output parameters for stored procedures
Posted: Tue Nov 08, 2011 5:48 am
by Alex K.
Hello,
Can you please send us a sample data for analysis.
Thank you.
input and output parameters for stored procedures
Posted: Tue Nov 08, 2011 9:05 am
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
input and output parameters for stored procedures
Posted: Thu Nov 10, 2011 3:36 am
by HighAley
Hello.
Sorry, we need more time to answer your question.
Thank you.
input and output parameters for stored procedures
Posted: Mon Nov 14, 2011 5:18 am
by Alex K.
Hello,
Unfortunately, on current moment, output parameters is not supported in our product.
Thank you.