cx_Oracle.DatabaseError: ORA-00936: missing expression
Help: https://docs.oracle.com/error-help/db/ora-00936/
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\flask\app.py", line 1511, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\flask\app.py", line 919, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\flask\app.py", line 917, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\flask\app.py", line 902, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) # type: ignore[no-any-return]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "D:\python\excel_tool\app.py", line 35, in index
result_df = pd.read_sql(query, conn)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\pandas\io\sql.py", line 706, in read_sql
return pandas_sql.read_query(
~~~~~~~~~~~~~~~~~~~~~^
sql,
^^^^
...<6 lines>...
dtype=dtype,
^^^^^^^^^^^^
)
^
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\pandas\io\sql.py", line 2738, in read_query
cursor = self.execute(sql, params)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python313\Lib\site-packages\pandas\io\sql.py", line 2686, in execute
raise ex from exc
pandas.errors.DatabaseError: Execution failed on sql 'SELECT * FROM 病人信息 WHERE ID IN (5222******8419,5222******0035,5222******0024,5222******2424,5222******041X,5222******8423,5222******362X,5222******5126,5222******8419,5222******0018,5222******2826,5222******0018,5222******0824,5222******2826,5222******8419,5222******8419,5222******0024,5222******0821,5222******6337,5222******3611,5222******1215,5222******0446,5222******4821,5222******6337,5222******0044,5222******0435,5222******3262,5222******8718,5222******842X,5222******8718,5222******1223,5222******1265)': ORA-00936: missing expression
Help: https://docs.oracle.com/error-help/db/ora-00936/
127.0.0.1 - - [16/May/2025 10:19:53] "POST / HTTP/1.1" 500 -
扫一扫
5128
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
