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