|
In your PL/SQL block, you can use a simple
IF-THEN-ELSE statement to choose how to call a stored
procedure, based on a value you have. To illustrate,
look at the following sample code:
BEGIN
SELECT pck_name, state_name INTO v_pck_name,
v_stat_name
FROM xxx_table
WHERE state_name='XXX';
-- Depending on package name, run the appropriate
package
IF (v_pck_name='PKG1') THEN
exm_pkg1.pr_exam(x,x);
ELSIF (v_pck_name='PKG2') THEN
exm_pkg2.pr_exam(x,x);
ELSE
DBMS_OUTPUT.PUT_LINE('No valid package');
END IF;
END;
It should be easy to see how the IF-THEN-ELSE is used
to determine which package to use.
For More Information
|
