Insert into Oracle

, ,
1

Can you explain us the reason of sending null to insert?is this some testing you want to check output?

2

Hi Vinod,

    You have to use execSql for this situation there you can use

oracle functions nvl().Example i am sending below.

 insert into schemaname.TableName(HUB,COMMODITY,PRODUCT,sell_price,offer_sellPrice) values('%HUB%','%COMMODITY%','%PRODUCT%',to_number(nvl(trim('%sell_Price%'),'')),to_number(nvl(trim('%offer_sellPrice%'),'')))

Here my see_Price,offer_sellPrice columns in data base are Numbers.
Now if you are inserting Null values,You don’t get any Exceptions.

Now before calling this service You have to set empty hardcoded
values for the fields sell_Price,sell_OfferPrice in a map.Hope
this will work for you.

Thanks,
SriniK

3

Can you explain us the reason of sending null to insert?is this some testing you want to check output?