Home > Archive > Visual Basic Crystal Reports > January 2006 > stored procedures with parameters
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
stored procedures with parameters
|
|
| Eitan M 2006-01-31, 4:11 am |
| Hello,
Can I use stored procedure (Oracle 9i) , that uses parameters
(the parameter is a formula field).
I want to link a parameter to a stored procedure, and put the results on the
report.
i.e :
use of my_package.my_func({param1}).
How can I do that ?
Need sample, please.
Thanks :)
| |
| Eitan M 2006-01-31, 8:00 am |
| For Crystal 8.5, Oracle 9i.
I see that I can do in crystal :
in option -> database tab ->
I have checked the option "Stored procedures".
I have succeed insert valid stored procedure :
CREATE OR REPLACE procedure TEMP_X(p_i in number) is
dummy_p number;
begin
null;
END;
But, when I try to use that stored procedure :
database menu -> add database to report,
and .... choosing the stored procedure, puting the parameter p_i, with value
= 1, and press OK,
I am getting the message :
ORA-01001 : Invalid cursor.
How can I overcome this problem ?
Thanks :)
|
|
|
|
|