推荐最新

SQLAlchmey调用存储过程获取出参报错ORA-00936: missing expression，该如何解决？

Oracle存储过程代码如下： create procedure test_procedure( id_in in number, del_num out number ) as begin select count(*) into del_num from test t where t.id = id_in ; delete from test t where t.id = id_in ; commit; end; / python调用代码如下： from sqlalchemy import create_engine , text from sqlalchemy.orm import sessionmaker from configs import url # 创建数据库连接 engine = create_engine(url) # 创建会话 Session = sessionmaker(bind=engine) session = Session() # 调用存储过程 result = session.execute(text("CALL test_procedure(:param1, @out_param)"), {'param1': 3}) # 获取输出参数的值 out_param_value = session.execute("SELECT @out_param").scalar() # 打印输出参数的值 print(out_param_value) 执行python报错信息： DatabaseError: (cx_Oracle.DatabaseError) ORA-00936: missing expression 咨询了GPT给了如下的代码： from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from sqlalchemy import outparam from configs import url # 创建数据库连接 engine = create_engine(url) # 创建会话 Session = sessionmaker(bind=engine) session = Session() # 调用存储过程 result = session.execute("BEGIN test_procedure(:alarmid, :del_num); END;", {'alarmid': 123, 'del_num': outparam.Parameter(int)}) # 获取输出参数的值 out_param_value = result.fetchone()['del_num'] # 打印输出参数的值 print(out_param_value) 结果报错： AttributeError: 'function' object has no attribute 'Parameter' 所以究竟怎么才能通过SQLAlchmey调用存储过程正常获取出参呢？

浏览量383

今天吃什么你说吧

oracle查询不用order by如何取最后一条数据？

如题，本身from后的数据表是用子查询出来的，无法用某种方式进行order by，但是要取查询结果的最后一条应该怎么写？

浏览量230

型男不是我还是谁

主流的Oracle DB 客户端是哪个？？

如题，是PL/SQL？SQL Developer？Navicat？还是别的？？哪个最好用啊？？

浏览量208

ApplePro

如下mysql语句，为什么加上ORDER BY t.CREATED_Date DESC后速度变得特别慢？

不加ORDER BY t.CREATED_Date DESC查询需要2秒加上后，查询需要15秒如果单独查询一个rd_pro_inventory_temp表的话，加不加都是几毫米而已，这是为什么呀？ SELECT t.LAST_UPD_BY, t.LAST_UPD_DATE, CASE WHEN t.ADD9 = 0 THEN det.item_code ELSE NULL END AS LOC_CODE, CASE WHEN t.ADD9 = 1 THEN det.item_code ELSE NULL END AS PRODUCT_CODE FROM rd_pro_inventory_temp t LEFT JOIN ( SELECT tem_desc, factory_code, GROUP_CONCAT(item_code) AS item_code FROM rd_pro_inventory_temp_det GROUP BY tem_desc, factory_code ) det ON det.tem_desc = t.TEM_DESC AND det.factory_code = t.FACTORY_CODE WHERE 1 = 1 AND t.active_flag = '1' AND t.FACTORY_CODE = '6640' ORDER BY t.CREATED_Date DESC