View refcursor results in Toad 13
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I just updated to Toad 13. In Toad 12 (and I thought earlier this week in Toad 13), when I ran a procedure from the Schema Browser, I would put in the arguments on the Arguments tab, and then choose 'Fetch into memory (view in grid)' in the Output Options tab.
Now, when it finishes, there is a PL/SQL Results tab, but no grid. There's got to be some setting, somewhere, but where?
My procedure has an in/out refcursor, and I load the results into the cursor. The output option seems like it should be enough.
oracle-11g toad
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
add a comment |
I just updated to Toad 13. In Toad 12 (and I thought earlier this week in Toad 13), when I ran a procedure from the Schema Browser, I would put in the arguments on the Arguments tab, and then choose 'Fetch into memory (view in grid)' in the Output Options tab.
Now, when it finishes, there is a PL/SQL Results tab, but no grid. There's got to be some setting, somewhere, but where?
My procedure has an in/out refcursor, and I load the results into the cursor. The output option seems like it should be enough.
oracle-11g toad
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
I've found a work-around: I double-clicked on the word (CURSOR) in the Output box under the PL/SQL results. And waited. Eventually, an output window with the name of my cursor showed up with the data in a grid. That's the grid I want, the one I've always just gotten. I don't see a way to pin it, and it's free-floating.
– thursdaysgeek
Feb 5 at 19:05
add a comment |
I just updated to Toad 13. In Toad 12 (and I thought earlier this week in Toad 13), when I ran a procedure from the Schema Browser, I would put in the arguments on the Arguments tab, and then choose 'Fetch into memory (view in grid)' in the Output Options tab.
Now, when it finishes, there is a PL/SQL Results tab, but no grid. There's got to be some setting, somewhere, but where?
My procedure has an in/out refcursor, and I load the results into the cursor. The output option seems like it should be enough.
oracle-11g toad
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
I just updated to Toad 13. In Toad 12 (and I thought earlier this week in Toad 13), when I ran a procedure from the Schema Browser, I would put in the arguments on the Arguments tab, and then choose 'Fetch into memory (view in grid)' in the Output Options tab.
Now, when it finishes, there is a PL/SQL Results tab, but no grid. There's got to be some setting, somewhere, but where?
My procedure has an in/out refcursor, and I load the results into the cursor. The output option seems like it should be enough.
oracle-11g toad
oracle-11g toad
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
asked Feb 5 at 17:33
thursdaysgeekthursdaysgeek
1,23381830
1,23381830
I've found a work-around: I double-clicked on the word (CURSOR) in the Output box under the PL/SQL results. And waited. Eventually, an output window with the name of my cursor showed up with the data in a grid. That's the grid I want, the one I've always just gotten. I don't see a way to pin it, and it's free-floating.
– thursdaysgeek
Feb 5 at 19:05
add a comment |
I've found a work-around: I double-clicked on the word (CURSOR) in the Output box under the PL/SQL results. And waited. Eventually, an output window with the name of my cursor showed up with the data in a grid. That's the grid I want, the one I've always just gotten. I don't see a way to pin it, and it's free-floating.
– thursdaysgeek
Feb 5 at 19:05
I've found a work-around: I double-clicked on the word (CURSOR) in the Output box under the PL/SQL results. And waited. Eventually, an output window with the name of my cursor showed up with the data in a grid. That's the grid I want, the one I've always just gotten. I don't see a way to pin it, and it's free-floating.
– thursdaysgeek
Feb 5 at 19:05
I've found a work-around: I double-clicked on the word (CURSOR) in the Output box under the PL/SQL results. And waited. Eventually, an output window with the name of my cursor showed up with the data in a grid. That's the grid I want, the one I've always just gotten. I don't see a way to pin it, and it's free-floating.
– thursdaysgeek
Feb 5 at 19:05
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fsuperuser.com%2fquestions%2f1402338%2fview-refcursor-results-in-toad-13%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 Super User!
- 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%2fsuperuser.com%2fquestions%2f1402338%2fview-refcursor-results-in-toad-13%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
I've found a work-around: I double-clicked on the word (CURSOR) in the Output box under the PL/SQL results. And waited. Eventually, an output window with the name of my cursor showed up with the data in a grid. That's the grid I want, the one I've always just gotten. I don't see a way to pin it, and it's free-floating.
– thursdaysgeek
Feb 5 at 19:05