Calling Stored Procedures Using Variables

Hi,
I'm developing a front-end for some stored procedures using Forms 4.5. The form will read in a list of tests, the package they are stored in, the procedure name for each, and a list of parameters for each. Once they are read in, I list them all with checkboxes allowing the users to "check" which tests they wish to run.

My problem is I would like to not hard code any procedure calls in the form, but rather, somehow, since I have all the information needed (package, procedure name, parameters required), call each stored procedure using variable names. This way, I can add new tests to the test table, but not have to alter the front-end form.

Is there a way to call a stored procedure using only variable names? If not, does anyone have any suggestions how I should go about doing this?

Thanks,
Ron Watson

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 14:37:29 CST