Skip to content Skip to sidebar Skip to footer

Cx_Oracle: Using PL/SQL RECORD Types As Arguments To Stored Procedures

I'm attempting to call AP_VENDOR_PUB_PKG.CREATE_VENDOR from cx_Oracle (This is an Oracle R12 stored procedure) It requires an argument that is a predefined PL/SQL RECORD type. (AP_

Solution 1:

I have been able to get past this problem by using

type_obj = connection.gettype('AP_VENDOR_PUB_PKG_R_VENDOR_RE')
obj = type_obj.newobject()

Note that the name is limited to 29 characters, and the period (.) has been replaced with underscore (_)


Post a Comment for "Cx_Oracle: Using PL/SQL RECORD Types As Arguments To Stored Procedures"