Insertion of Float and Date

I have created an Oracle table using JDBC adapter CustomSQL service
in WM Developer6.1
create table emp(eno Number(3),
ename varchar2(10),
doj Date,
salary number(7,2))
when i tried to insert values it provides null values for the fields except for the column ename.
what i have to do for inserting date and number values.
i have just started wm so please help me…


If you are sure emp table is created successfully,then you can use InsertSQL template and using this for Number,date etc… choose the JDBC FieldType as java.lang.string.


Thanks for your Help RMG

Thanks for your Help RMG