This content has been marked as final. Show 3 replies
1 person found this helpful
my database columns are anonymousWhat database is that and what actually are the data types in the database? I think the dbadapter schema is not properly defined... Or you're using not supported database/types...
In the actual database the column types are varchar2. But when I drag an invoke from the bpel constructs I associate it with by DBadapter partner link and click the button automatically create input variables. It creates an xsd and this is what one of the elements looks like.
When I do an assign and try to assign the values from the humantasks_globalvariables xsd there types look like this.
<xs:element name="anyvalue"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20"/> </xs:restriction> </xs:simpleType> </xs:element>
and the input variable I automatically generated look like this.
I figured it out. This is all you have to do. Just go to the xsd file that has the same name as your DB adapter partner link. So lets say you called you DB adapter Flag-O-Rama you will look for the file Flag_O_Rama_table.xsd
on the design tab expand the first complex type and where it says restricts, change that to type. Just click on it and a drop down box will appear.
now the schema looks like this
<xs:complexType name="Test"> <xs:sequence> <xs:element name="anyvalue" type="xs:string"/> </xs:sequence> </xs:complexType>