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

Thread: calling varying stored proc

Threaded View

  1. #7
    Join Date
    Feb 2009
    Posts
    4

    Talking it works

    fantastic this works, now find a way of returning values from the inner procedure.
    solution is :
    execute immediate 'begin ' || v_broutin || '( _credit, :v_employee ,:v_ret); end;'
    using in p_creditor, IN p_employee, in out v_sql;

    where v_broutin is the name of the stored proc
    Last edited by fjwagemakers; 02-23-2009 at 09:46 AM.

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