Hi Tom,

I have created a Java program as below and have compiled it as Java object in my Oracle Database. This Java program works fine and creates an excel file and save it in my Window's C:\ folder when I try it as from my eclipse IDE.
But when I call the same in my database it is not throwing any error, but the file is not generated in the specified path.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "CreateExcel"
AS package CreateExcel;
import java.io.*;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;

public class CreateExlFile{
public static java.lang.String GenerateExcel() {
try {
String filename = "C:\\Temp\\NewExcelFile.xls" ;
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("FirstSheet");
HSSFRow rowhead = sheet.createRow((short)0);
rowhead.createCell(0).setCellValue("No.");
rowhead.createCell(1).setCellValue("Name");
rowhead.createCell(2).setCellValue("Email");
HSSFRow row = sheet.createRow((short)1);
row.createCell(0).setCellValue("1");
row.createCell(1).setCellValue("MohamedAnas");
row.createCell(2).setCellValue("MohamedAnas@gmail.com");
FileOutputStream fileOut = new FileOutputStream(filename);
System.out.println(fileOut);
workbook.write(fileOut);
fileOut.close();
System.out.println("Your excel file has been generated!");

} catch ( Exception ex ) {
System.out.println(ex);
return "1";
}
return "0";
}

}

CREATE or replace function CreateExcelFile return varchar2
AS LANGUAGE JAVA
NAME 'CreateExcel.CreateExlFile.GenerateExcel() return java.lang.String';
/

select CreateExcelFile from dual;

This is giving me an output as 0 as there is no error. But I cannot find the file in my C:\Temp\ path.