I have a procedure defined as:
(PceCustomRouteRefCur OUT PCE_CUSTOM_ROUTE_REF_CUR_TYPE, MillCustRefCur OUT MILL_CUST_REF_CUR_TYPE,
PceLineUpVerRefCur IN PCE_LINEUP_VER_REF_CUR_TYPE);
That makes for two record sets coming out and I can deal with the output record sets as per the Oracle OLE DB instructions WHAT I CAN NOT FIGURE OUT IS:
1) Can you pass in a record set INTO an oracle procedure?
If so, how?
2) If you can not (and I don't think you can) then is it possible to passing several arrays (one per column)? What would the create parameter statement look like on the VB
side and what variable type needs te used on the Oracle side.
If you have any sample code that comes close to this situation please pass it on. I really don't want to have to pass in a formatted string that I will have to parse as part of the oracle programme.