This content has been marked as final. Show 2 replies
PL/SQL tables of records are unique to the PL/SQL engine and have no meaning outside that context (much like a C++ class would mean nothing to generic 'C'). You can use a REF CURSOR to return records or you can return arrays of user defined types.
Thank you mark. After lot of experimenting, I was able to return a varray of composite object type. By doing so , I used a OO4O parameter object.after executign the procedure from VB, Iam able to get the output array but which only has the interface of a parameter object. As this object does not support count, last, first etc. I cannot determine the upper bound of this returned varray parameter by any properties or using Ubound(). I had to use a second parameter of number type which returns the upper bound of the array.