Generate a excel from ORACLE DB

Four Stars

Generate a excel from ORACLE DB

Hello all,

I'm triyng to export to excel file base a oracle sql statement and getting the error below:

I'm sending the error and job screen attached


Accepted Solutions
Thirteen Stars

Re: Generate a excel from ORACLE DB

@richardl,when you were generating Excelfile,in file name you might have "\",please replace "\" with "/" and check.

Manohar B

All Replies
Nine Stars

Re: Generate a excel from ORACLE DB

Please provide the ExcelFile properties screen shot. I think you have some issue with settings.

 

Regards,

 

Veeru Boppudi
Six Stars

Re: Generate a excel from ORACLE DB

@richardl
It seems from DB table, a column contain a string with \ character (escape character in Java) which is trying to write in excel file. So if you want this escape character \ in your string, you need to escape the escape character and type \\ for avoid this error.


Hope it helps!

Thanks,


Regards,
Mohit
Thirteen Stars

Re: Generate a excel from ORACLE DB

@richardl,when you were generating Excelfile,in file name you might have "\",please replace "\" with "/" and check.

Manohar B

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.