cursor.fetchall() throws index out or range error
I have an issue which I am not sure where the root cause is:
I use python cx_Oracle to connect to an Oracle DB.
cursor.fetchall() returns me records in this format [(4352,)]
I want to retrieve the '4352' so i proceed to do this: pk = cursor.fetchall()[0][0]
However i get: IndexError: list index out of range
I am not sure what I am doing wrong since when i manually create this return object on my python console as such: item = [(4352,)], I can retrieve the '4352' by calling item[0][0]
Thanks
python-3.6 cx-oracle index-error
asked Nov 23 '18 at 10:22
AKJAKJ
7610
add a comment |
I have an issue which I am not sure where the root cause is:
I use python cx_Oracle to connect to an Oracle DB.
cursor.fetchall() returns me records in this format [(4352,)]
I want to retrieve the '4352' so i proceed to do this: pk = cursor.fetchall()[0][0]
However i get: IndexError: list index out of range
I am not sure what I am doing wrong since when i manually create this return object on my python console as such: item = [(4352,)], I can retrieve the '4352' by calling item[0][0]
Thanks
python-3.6 cx-oracle index-error
asked Nov 23 '18 at 10:22
AKJAKJ
7610
add a comment |
I have an issue which I am not sure where the root cause is:
I use python cx_Oracle to connect to an Oracle DB.
cursor.fetchall() returns me records in this format [(4352,)]
I want to retrieve the '4352' so i proceed to do this: pk = cursor.fetchall()[0][0]
However i get: IndexError: list index out of range
I am not sure what I am doing wrong since when i manually create this return object on my python console as such: item = [(4352,)], I can retrieve the '4352' by calling item[0][0]
Thanks
python-3.6 cx-oracle index-error
asked Nov 23 '18 at 10:22
AKJAKJ
7610
I have an issue which I am not sure where the root cause is:
I use python cx_Oracle to connect to an Oracle DB.
cursor.fetchall() returns me records in this format [(4352,)]
I want to retrieve the '4352' so i proceed to do this: pk = cursor.fetchall()[0][0]
However i get: IndexError: list index out of range
I am not sure what I am doing wrong since when i manually create this return object on my python console as such: item = [(4352,)], I can retrieve the '4352' by calling item[0][0]
Thanks
python-3.6 cx-oracle index-error
python-3.6 cx-oracle index-error
asked Nov 23 '18 at 10:22
AKJAKJ
7610
asked Nov 23 '18 at 10:22
AKJAKJ
7610
asked Nov 23 '18 at 10:22
AKJAKJ
7610
asked Nov 23 '18 at 10:22
AKJAKJ
7610
asked Nov 23 '18 at 10:22
AKJAKJ
7610
7610
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Are you sure about the list returned by the fetchall() statement?
It looks like the resulting list is empty.
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
add a comment |
I figured out what went wrong.
In my code i did something like this:
print(cursor.fetchall()) # line 56
a = cursor.fetchall()[0][0] # line 57
At line 56, the output of [(4352,)] is correct.
However at line 57, the cursor.fetchall() becomes a . This is because cursor.fetchall() is a generator. It has been automatically garbage-collected after line 56.
Therefore, if I wanted to extract out 4352 from the inner tuple, I had to call line 57 first and subsequently print(a) if I wanted to see the value of the return result from the database.
answered Nov 26 '18 at 3:31
AKJAKJ
7610
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53444838%2fcursor-fetchall-throws-index-out-or-range-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Are you sure about the list returned by the fetchall() statement?
It looks like the resulting list is empty.
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
add a comment |
Are you sure about the list returned by the fetchall() statement?
It looks like the resulting list is empty.
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
add a comment |
Are you sure about the list returned by the fetchall() statement?
It looks like the resulting list is empty.
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
Are you sure about the list returned by the fetchall() statement?
It looks like the resulting list is empty.
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
answered Nov 23 '18 at 19:03
cestMoiBaliBalocestMoiBaliBalo
5624
5624
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
add a comment |
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
Yes i am sure. I print out the result and got [(4532,)]
– AKJ
Nov 23 '18 at 19:12
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
You mean you did print(cursor.fetchall())?
– cestMoiBaliBalo
Nov 23 '18 at 19:53
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
Yes, i printed out cursor.fetchall()
– AKJ
Nov 23 '18 at 19:55
add a comment |
I figured out what went wrong.
In my code i did something like this:
print(cursor.fetchall()) # line 56
a = cursor.fetchall()[0][0] # line 57
At line 56, the output of [(4352,)] is correct.
However at line 57, the cursor.fetchall() becomes a . This is because cursor.fetchall() is a generator. It has been automatically garbage-collected after line 56.
Therefore, if I wanted to extract out 4352 from the inner tuple, I had to call line 57 first and subsequently print(a) if I wanted to see the value of the return result from the database.
answered Nov 26 '18 at 3:31
AKJAKJ
7610
add a comment |
I figured out what went wrong.
In my code i did something like this:
print(cursor.fetchall()) # line 56
a = cursor.fetchall()[0][0] # line 57
At line 56, the output of [(4352,)] is correct.
However at line 57, the cursor.fetchall() becomes a . This is because cursor.fetchall() is a generator. It has been automatically garbage-collected after line 56.
Therefore, if I wanted to extract out 4352 from the inner tuple, I had to call line 57 first and subsequently print(a) if I wanted to see the value of the return result from the database.
answered Nov 26 '18 at 3:31
AKJAKJ
7610
add a comment |
I figured out what went wrong.
In my code i did something like this:
print(cursor.fetchall()) # line 56
a = cursor.fetchall()[0][0] # line 57
At line 56, the output of [(4352,)] is correct.
However at line 57, the cursor.fetchall() becomes a . This is because cursor.fetchall() is a generator. It has been automatically garbage-collected after line 56.
Therefore, if I wanted to extract out 4352 from the inner tuple, I had to call line 57 first and subsequently print(a) if I wanted to see the value of the return result from the database.
answered Nov 26 '18 at 3:31
AKJAKJ
7610
I figured out what went wrong.
In my code i did something like this:
print(cursor.fetchall()) # line 56
a = cursor.fetchall()[0][0] # line 57
At line 56, the output of [(4352,)] is correct.
However at line 57, the cursor.fetchall() becomes a . This is because cursor.fetchall() is a generator. It has been automatically garbage-collected after line 56.
Therefore, if I wanted to extract out 4352 from the inner tuple, I had to call line 57 first and subsequently print(a) if I wanted to see the value of the return result from the database.
answered Nov 26 '18 at 3:31
AKJAKJ
7610
answered Nov 26 '18 at 3:31
AKJAKJ
7610
answered Nov 26 '18 at 3:31
AKJAKJ
7610
answered Nov 26 '18 at 3:31
AKJAKJ
7610
7610
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53444838%2fcursor-fetchall-throws-index-out-or-range-error%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
