You and is there any way to crack, after baidu search is ORA - 03113 related explanation, and python absent
Premise is to access only to query the database as a SQL will quote after I performed many times this error
Code is probably like this
Scconn_cmra=cx_Oracle. Connect (' dbquery/[email protected]/crmadb ')
Sccurs_cmra=scconn_cmra. Cursor ()
Sql1="select a.a ttr_value, b.a ttr_value from ur_usersvcattrtrace_info a, ur_usersvcattrtrace_info b" \
"Where Anderson d_No=b.i d_No (+)" \
"And a.s vcins_id=b.s vcins_id (+)" \
"And a.a ttr_id='23 b632" \
"And a.a ttr_value=https://bbs.csdn.net/topics/:userid "
"And '23 b628=b.a ttr_id (+)" \
"And a.e xp_date & gt; Sysdate \
""And sysdate
Sccurs_cmra. Execute (None, {' userid ': userid})
Error message
The Exception in the thread thread - 18:
Traceback (the most recent call last) :
The File "D: \ Python \ Python37 \ lib \ threading py", line 926, in _bootstrap_inner
The self. The run ()
The File "D: \ Python \ Python37 \ lib \ threading py", line 870, in the run
Self. _target (, * * * self. _args self. _kwargs)
The File "D:/study/MBHDZ. Py", line 52, in qywaddfunc
Sccurs_cmra. Execute (None, {' userid ': userid})
Cx_Oracle. OperationalError: ORA - 03113: the communication channel end file
The process ID: 24905638
The session ID: 2612 serial number: 27740