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"