You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » having trouble selecting on a Oracle decimal type and Oracle date type
#1 2012-07-05 18:17:13
- rphilips7161
- New member
- Registered: 2012-05-08
- Posts: 3
having trouble selecting on a Oracle decimal type and Oracle date type
I am having trouble selecting on a Oracle decimal type and Oracle date type in tMap or tFilter. My Oralce table has a decimal type column, a date type column, and various others.
I am trying to select on the decimal type and get the error:
Incompatible operand types BigDecimal and int
I have put in 5069457 as the value. If I put in 5069457.0 as the value I get the same thing but it says double.
I am also trying to select on the date type and get the error:
The method compareTo(Date) in the type Date is not applicable for the arguments (int)
I have put in 18-06-2012 as the value.
Offline
#3 2012-07-06 14:49:58
- rphilips7161
- New member
- Registered: 2012-05-08
- Posts: 3
Re: having trouble selecting on a Oracle decimal type and Oracle date type
Thanks for your response. I have attached screen shots. I put one of the criteria in tMap and the other in tFilterRow.
I subsequently put my criteria in the select statement of tOracleInput which worked, but I am still interested in knowing why these won't work in tMap or rFilterRow.
Thanks,
Bob
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » having trouble selecting on a Oracle decimal type and Oracle date type