dave-csc opened a new issue, #6646: URL: https://github.com/apache/hop/issues/6646
### Apache Hop version? 2.17 ### Java version? 17.0.2 ### Operating system Linux ### What happened? When passing boolean fields to a **Table output** transform that writes to an Oracle database: - it seems that Hop 2.17 doesn't handle the conversion correctly: you can get an error from Oracle like `ORA-01722: invalid number` - with Hop 2.16 and below, the conversion is handled: `true` values are converted to integer 1, `false` to 0 (Note that Oracle doesn't support boolean columns, so a conversion is needed) **Workaround:** use a **Select values** before Table output to convert the boolean fields into integers (the same conversion done automatically by Hop <2.16 is performed) ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
