Page 1 of 1
SQL Stored Procedure
Posted: Wed Oct 23, 2002 12:34 pm
by bstreet
When I try to pass a parameter using a Stored Procedure I get an error message saying parameter value was not supplied. Is there a way I can use parameters in a stored procedure?____Thanks__Butch__;)
=> RE: SQL Stored Procedure
Posted: Thu Oct 24, 2002 7:00 am
by kfleming
Are you using RI_REPLACE to pass the parameter?____Kathleen__R&R Support
==> RE: SQL Stored Procedure
Posted: Thu Oct 24, 2002 1:19 pm
by bstreet
Kathleen,__I have an RR report based on a stored procedure, the stored procedure is set up to require paramaters. I need to pass these paramters into the stored procedure. So when I run my report can I pass a paramater to the stored procedure so I can get the result set I need.____
===> RE: SQL Stored Procedure
Posted: Thu Oct 24, 2002 3:10 pm
by kfleming
You would need to put the parameter in double brackets in the saved report__EXEC MYPROC <<param1>>____At runtime you would then use RI_REPLACE to set the value of param1__for example:__RI_REPLACE=KANSAS____will do an __EXEC MYPROC KANSAS____Kathleen__R&R Support