-
How to Execte a procedure in another procedure using Dynamic SQL
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
-
Why use dynamic sql? Can't you just call it?
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|