1 Reply Latest reply: Feb 28, 2013 5:21 PM by rp0428 RSS

    pass parameter from 1 stored proc to another stored proc

    992876
      Hi. How to pass a parameter from 1 stored proc to another stored proc??

      1) stored proc that creates report
      2) stored proc that send report

      I want to pass the filename from stored proc 1 to stored proc 2. Thanks!
        • 1. Re: pass parameter from 1 stored proc to another stored proc
          rp0428
          >
          Hi. How to pass a parameter from 1 stored proc to another stored proc??

          1) stored proc that creates report
          2) stored proc that send report

          I want to pass the filename from stored proc 1 to stored proc 2. Thanks!
          >
          There are several ways:

          1. have proc1 call proc2 and pass the filename as a parameter value
          2. have proc1 set a package variable to the file name. Then proc2 can access the file name from the package variable
          3. have proc1 set a CONTEXT parameter value to the filename. Then proc2 can use the SYS_CONTEXT function to access the filename.