Please help : toByteArray(myBlob) fails ???

[achana chan]

I hope Michael reads this...
I am trying

 public byte[] empPicture

as suggested.
On the input side (where I am getting the record from Oracle) I now changed the code to this :

//
// -----------------
//
  public empRecord query(int empno)
  {  
    empRecord thisRec = null;
    try
    {  
      prepStmt.setInt(1, empno); // placeholder for "?" in position 1
      ResultSet rset = prepStmt.executeQuery();
      System.out.println("\n<<ORA>>AllEmpTN : executed prepStmt, record : ");
      if (rset.next())
      {
        // Create a new record object...
        thisRec = new empRecord();
        //
        // Set the values...
        thisRec.empno = rset.getInt("empno");
        thisRec.ename = rset.getString("ename");
        thisRec.fname = rset.getString("fname");         
        thisRec.job = rset.getString("job");
        thisRec.mgr = rset.getInt("mgr");
        thisRec.hiredate = rset.getDate("hiredate");
        thisRec.sal = rset.getDouble("sal");
        thisRec.comm = rset.getDouble("comm");
        thisRec.deptno = rset.getInt("deptno");
        [B]BLOB picBLOB = ((OracleResultSet) rset).getBLOB("picture");
        thisRec.picture = toByteArray(picBLOB);[/B] :confused:  
        //
        System.out.println(thisRec.ename+","+thisRec.fname+","+thisRec.job+","+thisRec.mgr+","+
                           thisRec.hiredate+","+thisRec.sal+","+thisRec.comm+","+thisRec.deptno);
      } 
    } //end of try-block
    catch (SQLException ex)
    // catch(Exception ex)
    { 
      ex.printStackTrace();
      thisRec = null;
    }
    // okay, let's have a look at the record...
    return thisRec;
  } //end of method empQuery();

[achana chan]

Thread closed.
I managed to fix it on the hint that Michael gave me about using

public bytearray[] empPicture

instead of Blob.
Thank you !