1 import SQLRConnection; 2 import SQLRCursor; 3 4 public class myclass { main()5 public static main() { 6 7 SQLRConnection con=new SQLRConnection("sqlrserver",(short)9000,"/tmp/example.socket","user","password",0,1); 8 SQLRCursor cur=new SQLRCursor(con); 9 10 cur.prepareQuery("begin select image into :image from images; select description into :desc from images; end;"); 11 cur.defineOutputBindBlob("image"); 12 cur.defineOutputBindClob("desc"); 13 cur.executeQuery(); 14 15 String image=cur.getOutputBindBlob("image"); 16 long imagelength=cur.getOutputBindLength("image"); 17 18 String desc=cur.getOutputBindClob("desc"); 19 String desclength=cur.getOutputBindLength("desc"); 20 21 con.endSession(); 22 23 ... do something with image and desc ... 24 25 } 26 } 27