Shulou(Shulou.com)06/01 Report--

This article tests calling PL/SQL through cx_Oracle in Python.

First, create a simple stored procedure on the database side.

Create or replace procedure test_msg (i_user in varchar2, o_msg out varchar2) isbegin o_msg: = i_user | |', Good Morningboat investors

Then, start making stored procedure calls on the Python command line.

Import cx_Orace as cxconn = cx.connect ('database connecting string') cursor = conn.cursor () # declare variable user =' Nick' # plsql input parameter msg = cursor.var (cx_Oracle.STRING) # plsql output parameter # call stored procedure cursor.callproc ('test_msg', [user, msg]) # [' Nick', 'Nick, Good matching'] # print return value print msg # print msg.getvalue () # Nick Good mornings # Resource closes cursor.close () conn.close ()

Extended reading:

There is a conversion relationship among the object types of stored procedures, cx_Oracle and Python. The details are as follows:

Oracle

Cx_Oracle

Python

VARCHAR2

NVARCHAR2

LONG

Cx_Oracle.STRING

Str

CHAR

Cx_Oracle.FIXED_CHAR

NUMBER

Cx_Oracle.NUMBER

Int

FLOAT

Float

DATE

Cx_Oracle.DATETIME

Datetime.datetime

TIMESTAMP

Cx_Oracle.TIMESTAMP

CLOB

Cx_Oracle.CLOB

Cx_Oracle.LOB

BLOB

Cx_Oracle.BLOB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.