How to Execte a procedure in another procedure using Dynamic SQL

[preetham]

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

[DaPi]

Why use dynamic sql? Can't you just call it?

[preetham]

hi
yes i want to call a procedure from another procedure.

but called procedure will be having in and inout parameters.
how can i do that
regards
preetham