python - cx_Oracle: Using PL/SQL RECORD types as arguments to stored procedures -
i'm attempting call ap_vendor_pub_pkg.create_vendor cx_oracle (this oracle r12 stored procedure) requires argument predefined pl/sql record type. (ap_vendor_pub_pkg.r_vendor_rec_type)
here's python code:
connection = cx_oracle.connect(...) cursor = connection.cursor() obj = cursor.var(cx_oracle.object, typename='ap_vendor_pub_pkg.r_vendor_rec_type') result = cursor.callproc('ap_vendor_pub_pkg.create_vendor', parameters=["1.0", "t", "t", "fnd_api.g_valid_level_full", obj])
this results in following exception:
cx_oracle.interfaceerror: object type not associated bind variable
what doing wrong? how call stored procedure requries record type?
i have been able past problem using
type_obj = connection.gettype('ap_vendor_pub_pkg_r_vendor_re') obj = type_obj.newobject()
note name limited 29 characters, , period (.) has been replaced underscore (_)
Comments
Post a Comment