Oracle: How do i manage two versions of a stored procedure at the same time?SQL Server: How to call stored...

Can you wish for more wishes from an Efreeti bound to service via an Efreeti Bottle?

Do error bars on probabilities have any meaning?

Empty optional argument or Not giving optional argument at all?

What is the reason behind this musical reference to Pinocchio in the Close Encounters main theme?

Is there any danger of my neighbor having my wife's signature?

What does @ mean in a hostname in DNS configuration?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

What does "don't have a baby" imply or mean in this sentence?

Exploding Numbers

Have any astronauts or cosmonauts died in space?

Using font-relative distances in tikzpictures

80-bit collision resistence because of 80-bit x87 registers?

How can I make my enemies feel real and make combat more engaging?

Why is quixotic not Quixotic (a proper adjective)?

How do I know my password or backup information is not being shared when creating a new wallet?

Is Screenshot Time-tracking Common?

I hate taking lectures, can I still survive in academia?

Is opening a file faster than reading variable content?

How can I differentiate duration vs starting time

Isn't a semicolon (';') needed after a function declaration in C++?

Why didn't Lorentz conclude that no object can go faster than light?

Which was the first story to feature space elevators?

Why do we divide Permutations to get to Combinations?

Why are `&array` and `array` pointing to the same address?



Oracle: How do i manage two versions of a stored procedure at the same time?


SQL Server: How to call stored procedure without schema name?With the advent of integrated source control, do stored procedure changes still need comments?How can I search the full text of a stored procedure for a value?Migrating stored procedure from Sybase to Oracle having temporary tablesHow to backup the current code of a stored procedure and its permissions as well?How to remove the WITH ENCRYPTION from the code of the procedure - via T-SQLHow properly call stored procedure from EXEC(SQL)?what does it mean if the last execution time of a stored procedure is emptyWhat's the difference between stored procedure and function in PostgreSQL 11?How to create stored procedure that returns query result?













0















Here is the situation:



There are some stored procedures (3 - 5 no's) already in production. we made some changes for a fix. It also involved changes to the code that is using these stored procedures.



I am looking for a strategy that can help us achieve this:



let the old code in production use the old version of the stored procedures. So when i deploy the newer version of the stored procedures, and the old code still running in production (no down time) it should use the old version of the stored procedure so the application does not break.



Once i deploy the new code, it should start using the newer version of the stored procedures.



TIA.









share



























    0















    Here is the situation:



    There are some stored procedures (3 - 5 no's) already in production. we made some changes for a fix. It also involved changes to the code that is using these stored procedures.



    I am looking for a strategy that can help us achieve this:



    let the old code in production use the old version of the stored procedures. So when i deploy the newer version of the stored procedures, and the old code still running in production (no down time) it should use the old version of the stored procedure so the application does not break.



    Once i deploy the new code, it should start using the newer version of the stored procedures.



    TIA.









    share

























      0












      0








      0








      Here is the situation:



      There are some stored procedures (3 - 5 no's) already in production. we made some changes for a fix. It also involved changes to the code that is using these stored procedures.



      I am looking for a strategy that can help us achieve this:



      let the old code in production use the old version of the stored procedures. So when i deploy the newer version of the stored procedures, and the old code still running in production (no down time) it should use the old version of the stored procedure so the application does not break.



      Once i deploy the new code, it should start using the newer version of the stored procedures.



      TIA.









      share














      Here is the situation:



      There are some stored procedures (3 - 5 no's) already in production. we made some changes for a fix. It also involved changes to the code that is using these stored procedures.



      I am looking for a strategy that can help us achieve this:



      let the old code in production use the old version of the stored procedures. So when i deploy the newer version of the stored procedures, and the old code still running in production (no down time) it should use the old version of the stored procedure so the application does not break.



      Once i deploy the new code, it should start using the newer version of the stored procedures.



      TIA.







      oracle stored-procedures





      share












      share










      share



      share










      asked 3 mins ago









      blogs4tblogs4t

      83




      83






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230414%2foracle-how-do-i-manage-two-versions-of-a-stored-procedure-at-the-same-time%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230414%2foracle-how-do-i-manage-two-versions-of-a-stored-procedure-at-the-same-time%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Armoriale delle famiglie italiane (Car) Indice Armi | Bibliografia | Menu di navigazioneBlasone...

          Why does this relation fail symmetry and transitivity properties?Properties of Relations. Reflexive,...

          why typing a variable (or expression) prints the value to stdout?Calling a function of a module by using its...