1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Converting a varchar2 to BLOB

Discussion in 'SQL PL/SQL' started by jdsnatl, Oct 28, 2009.

  1. jdsnatl

    jdsnatl Guest

    I scanned an image into a java applet, converted it to a byte array, encoded it with Base64, and then converted it into a String. I then passed this String to javascript so that I could access it from PL/SQL developer.

    From PL/SQL, how can I take that String, decode it, and convert it to a BLOB? The utl_encode package seems like it should do the trick decoding wise with utl_encode.base64_decode. However, aside from that, I could use some assistance.

    Any help is greatly appreciated.