Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

python query oracle db question

55138ad9-f0e9-4be9-b1fd-cad3ed8ad5aeMar 20 2016 — edited Apr 3 2016

my DB is oracle 11.

develop language is python 2.7.

i use following statement to get record from DB. and the row number is nearly 0.5 billion

statements:

sql = "select count(*) from dwrsdm.bl_inv_stock_erp "

cursor.execute(sql)

result = cursor.fetchall()

print result;

sql = "select * from dwrsdm.bl_inv_stock_erp"

cursor.execute(sql)

result = cursor.fetchall() -------error happen



error happen when it run the second " cursor.fetchall()", it prompt

"cx_Oracle.OperationalError: ORA-03113: "

I am sure the error happen for the return records is too huge. How can I solve the problem?




This post has been answered by Gaz in Oz on Apr 3 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2016
Added on Mar 20 2016
1 comment
1,749 views