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?
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
add a comment |
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
add a comment |
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
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
oracle stored-procedures
asked 3 mins ago
blogs4tblogs4t
83
83
add a comment |
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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