stored Procedure in different databases

[sikkilamkiran]

hi all,
I have a problem in accessing the procedure from different databases.
for example i have a procedure named test_procedure in a database called ORCL and the same procedure test_procedure in onother database called ORCL_NEW now the problem is i want to dynamically select the connection is it possible if yes how.
Please help me, its really urgent
Thanks in advance
kiran

 

[synapsevampire]

Please post your Crystal version, and Oracle version and connectivity used (assumed Oracle by the database name, correct me if I'm mistaken) then we can determine if it's possible.

You might use a Command Object with a parameter for the database in CR 9 and above.

Are you just using Crystal Reports, or are you calling them from an application or some other tool?

-k

 

[sikkilamkiran]

hi synapsevampire,
im using crystal XI integrated with Business objects and oracle 9i database.
the problem is i want to use dynamic database connection in repository and go for a report. but a stored proc cannot be used to create a report in repository .is it possible or else if i create a report in crystal alone is it possible to have a dynamic database connection or switch connections
please help me
regards
kiran