0 Replies Latest reply on Nov 19, 2012 11:55 AM by 792937

    OCIObjectSetAttr performance deteriorates when binding too many Type params


      In my application, when I passed a Type Array as parameter to the stored procedure and when the Type Array is large enough(normally 3000 type objects, each objects has about 15 attributes), the OCIObjectSetAttr performance deteriorates large enough from below 1 millisecond to 1~3 miliseconds.

      I am using OCI 11gR2, does anyone notice it and know how to optimize it?