Using Dynamic SQL - Oracle Documentation
Example 7-1 Invoking a Subprogram from a Dynamic PL/SQL Block-- Subprogram that dynamic PL/SQL block invokes: CREATE PROCEDURE create_dept ( deptid IN OUT NUMBER, dname IN VARCHAR2, mgrid IN NUMBER, locid ......