Skip to Content
0
Former Member
Sep 15, 2007 at 10:24 PM

Executing stored procedures

17 Views

Post Author: Steve22

CA Forum: Data Connectivity and SQL

I have created a stored procedure with two input parameters in a package on Oracle and connected into it ok from a Crystal XI report. The report asks for startdate and enddate parameters. However, the database needs to be updated first using the startdate and enddate supplied as input parameters to several other stored procedures. How can I achieve this?

Can I list all the update procedures in the same package and call them all from the connected procedure

I have heard that an add command is an option using and exec statement - can anyone expand on this?

I'd be glad to hear any options anyone can offer.