从python脚本使用光标输出参数调用oracle存储过程 [英] Call oracle stored procedure with cursor output parameter from python script

问题描述

我正在尝试从python脚本调用带有2 in和1 out参数的oracle存储过程。我遇到的问题是传递游标输出参数。

I am trying to call a oracle stored procedure with 2 in and 1 out parameter from python script. The problem I am having is passing a cursor out-parameter.

Oracle存储过程本质上是：

The Oracle stored procedure is essentially:

  PROCEDURE ci_lac_state 
     (LAC_ID_IN IN  VARCHAR2,  
      CI_ID_IN  IN  VARCHAR2 DEFAULT NULL,
      CGI_ID    OUT SYS_REFCURSOR)
  AS
  BEGIN
      OPEN cgi_id FOR
      ...
  END;

调用数据库的python代码为：

The python code calling to the database is:

  #! /usr/bin/python

  import cx_Oracle

  lac='11508'
  ci='9312'

  try:
      my_connection=cx_Oracle.Connection('login/passwd@db_name')
  except cx_Oracle.DatabaseError,info:
      print "Logon Error:",info
      sys.exit()

  my_cursor=my_connection.cursor()
  cur_var=my_cursor.var(cx_Oracle.CURSOR)

  my_cursor.callproc("cgi_info.ci_lac_state", [lac, ci, cur_var])

  print cur_var.getvalue()

游标值作为结果：

  <__builtin__.OracleCursor on <cx_Oracle.Connection to login@db_name>>

我在做什么错了？

谢谢。

推荐答案

我刚刚遇到过类似的问题。 cur_var 具有类型<类型'cx_Oracle.CURSOR'> 和 cur_var.getvalue（ ）获取类型为<类型'OracleCursor'> 的对象。要获取数据，您必须从OracleCursor对象获取它们。尝试例如：

I've just had similar issue. cur_var has type <type 'cx_Oracle.CURSOR'> and cur_var.getvalue() gets object of type <type 'OracleCursor'>. To get data you have to fetched them from the OracleCursor object. Try for example:

print cur_var.getvalue().fetchall()

要查看OracleCursor对象的更多功能，只需检查其目录：

To see more function of OracleCursor object just check its directory:

dir(cur_var.getvalue())

希望这对您有帮助！

这篇关于从python脚本使用光标输出参数调用oracle存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！