Hopefully some can help here...
I am having trouble with invoking a PLSQL web service from BPEL when the PLSQL procedure requires an Array Type.
I have some custom object types such as:
create type Friend as object
(
field1 varchar2(10),
field2 varchar2(10),
field3 varchar2(10),
)
/
create type FriendList as table of myType
/
create procedure insert_friend(p_friendlist in out nocopy FriendList)
is
begin
/* code */
end;
/
When I create the pl/sql web service in JDev, the WSDL includes the following
<complexType name="ArrayOforacle_friend_FriendUser" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<complexContent>
<restriction base="SOAP-ENC:Array">
<attribute ref="SOAP-ENC:arrayType" wsdl:arrayType="ns1:oracle_friend_FriendUser[]"/>
</restriction>
</complexContent>
</complexType>
On creating a partner link to this service, I have created default input/output variables. The input variable just has an array element that has 4 attributes (arrayType, offset, id and href). There is no way to assign (or transform) any values to the array itself.
Searching this forum reveals talk about bpel not being compatible with soap encoding. I've also heard there is a patch to fix this. Could anyone shed any light on this?
Cheers,
SR