How to dynamically call stored procedures in Oracle PL/SQL

Today, a colleague asked me how to dynamically call the stored procedure in Oracle PL/SQL. I think there should be no problem. I just tried OK, mainly using the execute immediate syntax, note that the in and out parameters are specified in using. The test example is as follows:

 

 

Create or replace function fnc_test2 (IP1 integer, ip2 integer) return integer is
Result integer;
Begin
Return (IP1 * ip2 );
End fnc_test2;

 

 

Create or replace function fnc_test1 return integer is
Result integer;
Vsql varchar2 (200 );
Begin
Vsql: = 'in in: Return: = fnc_test2 (: P1,: P2); end ;';
Execute immediate vsql
Using out result, 2, 3;
Return (result );
End fnc_test1;

 

 

SQL> select fnc_test1 () from dual;
 
Fnc_test1 ()
-----------
6
 
SQL>