Silly question but I hope some one can help me...!!!

[NexusBP]

Hi;

I have a BPEL Process that is inserting data into a SQL Server Table that has allows nulls to be set on some of the colums. If the data is fully populated then it inserts ok. However if the data has a null value and i try and insert i get a type cast error and the insert fails.

How do i handle null values in the assign to the DB BC. It dispalys setNull in the DBBC Schema but im not sure how to set it.

Please help.

Br

Lee

[Pavan Veeravarapu]

Some javascript/style in this post has been disabled (why?)

HI,
If you want to insert null values in to the column,  you need to set the  isNull attribute to true in the bpel mapper. Please find the below screen shot.





Thanks,
Pavan Veeravarapu.

NexusBP wrote:

Hi;

I have a BPEL Process that is inserting data into a SQL Server Table that
has allows nulls to be set on some of the colums. If the data is fully
populated then it inserts ok. However if the data has a null value and i try
and insert i get a type cast error and the insert fails.

How do i handle null values in the assign to the DB BC. It dispalys setNull
in the DBBC Schema but im not sure how to set it.

Please help. 

Br

Lee