DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to Execte a procedure in another procedure using Dynamic SQL

  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Unhappy 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

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Why use dynamic sql? Can't you just call it?

  3. #3
    Join Date
    Sep 2004
    Posts
    5
    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
  •  


Click Here to Expand Forum to Full Width