英文:
Call Postgresql Proocedure using python
问题
尝试使用Python运行PostgreSQL存储过程，但无法纠正错误。。
def call_procedure_without_arguments():try:connection = create_connection()if connection:cursor = connection.cursor()# 调用没有输入参数的存储过程procname = "call proc_test"cursor.callproc(procname)results = cursor.fetchall()print("Results:", results)# 提交更改（如果有）connection.commit()# 关闭游标和连接cursor.close()connection.close()print("存储过程成功执行。")else:print("连接失败。无法调用存储过程。")except Exception as e:print("错误：无法调用存储过程。", e)if __name__ == "__main__":call_procedure_without_arguments()
英文:
Trying to run a postgresql procedure using python but not able to rectify the error..
def call_procedure_without_arguments():try:connection = create_connection()if connection:cursor = connection.cursor()# Call the procedure without any input argumentsprocname = "call proc_test"cursor.callproc(procname)results = cursor.fetchall()print("Results:", results)# Commit the changes (if any)connection.commit()# Close the cursor and connectioncursor.close()connection.close()print("Procedure executed successfully.")else:print("Connection failed. Unable to call the procedure.")except Exception as e:print("Error: Unable to call the procedure.", e)if __name__ == "__main__":call_procedure_without_arguments()
答案1
得分: 0
根据Geeks for Geeks的文档：
engine = connector.cursor()engine.callproc('your_procedure')result = cursor.fetchall()
如果不起作用，请尝试添加括号 ()，根据Postgresql Tutorial：
conn = psycopg2.connect(dsn)cur.execute("CALL your_procedure();")conn.commit()
英文:
I am expecting that no arguments need to be passed. The documentation for this is different at different resources.
According to Geeks for Geeks
engine = connector.cursor()engine.callproc('your_procedure')result = cursor.fetchall()
If does not work try adding parenthesis (), according to Postgresql Tutorial:
conn = psycopg2.connect(dsn)cur.execute("CALL your_procedure();")conn.commit();
答案2
得分: 0
与名称callproc相反，它不适用于存储过程。它仅适用于函数：
https://www.psycopg.org/docs/cursor.html#cursor.callproc
注意
callproc()只能用于PostgreSQL函数，不能用于PostgreSQL 11中引入的存储过程，这些存储过程需要使用CALL语句来运行。请使用普通的execute()来运行它们。
因此：
cur.execute('call proc_test')
英文:
Contrary to the name callproc is not for procedures. It is for functions only:
https://www.psycopg.org/docs/cursor.html#cursor.callproc
>Note
>callproc() can only be used with PostgreSQL functions, not with the procedures introduced in PostgreSQL 11, which require the CALL statement to run. Please use a normal execute() to run them.
Therefore:
cur.execute('call proc_test')
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论