hi
how can i execute a procedure in another procedure using a dynamic sql.

Scenario is like below.

PROCEDURE p_region(chFlag VARCHAR2 DEFAULT 'C',
pc_Region IN OUT pkg_fe_base_dw.rc_datawindow )

i want to execute the ablove procedure in a new procedure called 'Generic_proc.

i want to execute the procedure p_region in new procedure and also to find out how many records it has processed in that procedure.
please help me.

regards
preetham