how do i read a clob data from a function written in oracle in java code

[renu]

Hi ,

I have a stored procedure written in oracle which returns a clob data .
How can i get the clob data into the file in java.

here is my code ....pls help me with any changes i have to do , so that it works.
Thank You in Advance for all the kind help in time .

//		The extract table now contains data in it.
		CallableStatement proc_stmt;		
		try {
			FileOutputStream fos;	
			fos = new FileOutputStream(new File(OutputFile),false);
			Writer out = new OutputStreamWriter(new BufferedOutputStream(fos));		
			proc_stmt = connection.prepareCall("{? = call PKG_EXTRACTION_DATA.F_CREATE_HEADER(?)}");	
//			Register the type of the return value		
			proc_stmt.registerOutParameter(1,OracleTypes.VARCHAR);	
//			proc_stmt.registerOutParameter(1,OracleTypes.CLOB);	
			proc_stmt.setString(2,user_id);
//			Execute and retrieve the returned value
			proc_stmt.execute();
//			String  retValue = proc_stmt.getString(1);
			Clob  retValue = proc_stmt.getClob(1);
//			out.write(retValue.toString());
			//get the character stream of our CLOB data
			//
			Reader reader = retValue.getCharacterStream();
			char[] buffer = new char[1];
			while(reader.read(buffer) > 0) {
				out.write(buffer);
			}			
//			out.write(retValue);
			out.write("\r\n");
			proc_stmt.close();

[Tolls]

Does that work?
If not then what problems are you encountering?