I need to convert a primary key Interger to a String. In the tMap I have written: (REF.REF_ID).toString() but the following error appears: "cannot invoke toString() on the primitive type int". How can I convert it? Thanks
I have replied to quick. With the expression (new Integer(REF.REF_ID)).toString() the tMap expression builder don't make an error anymore. But the tMap component falls in error. The convertion of interger to string for a primary key is not possible.
hi Shong, I am facing similar issue (converting string to char). My input schema is string/char and output schema is char column from OracleSP. It says datatype/argument mismatch when I run the job. Pls suggest.