Fetching the image field stored as a BLOB in oracle
In MySQL, all the image types (jpeg, gif, png, bmp) can be fetched easily by drag-drop of the BLOB field. In Oracle though, none of the images can be fetched like this. As a workaround, the image types other than bmp, can be fetched following the steps below: 1. Connect to the database and write a query that fetches the BLOB field. Preview it to check if the query fetches any data. 2. Right click on the "functions" header and add a new function. 3. In the dialog box for the New Function, double click on the "Scripts" and select the BHSExpression. Click "OK". 4. In the "Expression" field for the "BHSExpression", copy the following code: Object getValue() { var blobObject = dataRow.get("BLOB_COL"); long blobLength = blobObject.length(); byte[] blobContent = blobObject.getBytes((long)1, (int)blobLength); return Toolkit.getDefaultToolkit().createImage(blobContent); } This Javascript code will convert the BLOB field to an image f
