| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Calling Stored Procedures Using Variables
watsonr4_at_my-deja.com wrote:
>
> 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.
You can use DBMS_SQL to do it...
if the procedure name is in variable "x" you would parse/execute
'begin '||x||' end;'
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Dec 03 1999 - 05:51:02 CST
 |
 |