Oracle Developer Tools for Visual Studio

Hi,
attached two functions one for dumping the other for loading ...

public class Test {
private File fHandle = null;
private static String PATH = null ;
private BLOB bHandle = null;
private String fileName = null ;

protected void dumpBlobToFile() throws SQLException
{

FileOutputStream outstream = null;
InputStream instream = null;

try {
getFileHandle(); // Gets a new file handle.
if (bHandle != null)
instream = bHandle.getBinaryStream(); // Get the blob input stream
else
return ;

if (outstream == null)
outstream = new FileOutputStream(fHandle); // Get the file output stream.


// Read the input stream and write the output stream by chunks.
byte[] chunk = new byte[bHandle.getChunkSize()];
int i = -1;

while ((i = instream.read(chunk)) != -1) {
outstream.write(chunk, 0, i);
}
outstream.flush();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {

// Close the input and output stream.
if (instream != null) {
instream.close();
instream = null ;
}

if (outstream != null) {
outstream.close();
outstream = null ;
}

} catch (IOException e) {
e.printStackTrace();
}
}
}
protected void dumpFileToBlob() throws SQLException
{

FileInputStream instream = null;
OutputStream outstream = null;

try {
getFileHandle(); // Gets a new file handle.

if (bHandle != null) // Get the clob output stream
outstream = bHandle.getBinaryOutputStream();
else
return ;

if (instream == null)
instream = new FileInputStream(fHandle); // Get the file input stream.


// Read the input stream and write the output stream by chunks.
byte[] chunk = new byte[bHandle.getChunkSize()];
int i = -1;

while ((i = instream.read(chunk)) != -1) {
outstream.write(chunk, 0, i);
}
} catch (IOException e) {
e.printStackTrace();
} finally {
try {

// Close the input and output stream.
if (instream != null) {
instream.close();
instream = null ;
}

if (outstream != null) {
outstream.close();
outstream = null ;
}

} catch (IOException e) {
e.printStackTrace();
}
}
}

public void setPath(String path)
{
this.PATH = path ;
}
/**
* Get a file handle
*/
private void getFileHandle()
{
fHandle = new File(PATH + fileName);
}
}

EA