Insertion of Float and Date

, ,
1

hi,
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…

2

Parani,

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.

HTH,
RMG>

3

Thanks for your Help RMG

4

Thanks for your Help RMG