Oracle database - unsupported type

Version 1
    This document was generated from CDN thread

    Created by: Na How Yee on 13-12-2011 10:32:55 AM
    Hi,
     
    I have connected to Oracle database through ccx script. My Oracle database contains an attribute named 'FCONTENT' which is a BLOB type. However, it shows 'unsupported type' while I try to add field in 'DB Get' step. Please find attachment as the database field in 'DB Read' step.
    I need to store the .wav file into it, without 'FCONTENT', the .wav file can't be saved. Any ideas??
     
    Thanks,
    HowYee

    Subject: RE: Oracle database - unsupported type
    Replied by: Steven Pawlak on 24-02-2012 09:25:08 AM
    Na,

    Google seems to point to an issue with not having the Oracle JDBC driver in the path, so Java does not know what type to use for the BLOB in Oracle.

    The bigger question is what are you going to do with a BLOB in a voice based IVR system? Perhaps you should leave that off of the query.

    Subject: RE: Oracle database - unsupported type
    Replied by: Na How Yee on 26-02-2012 08:26:05 PM
    Hi Steven,

    You're right. The BLOB type is not supported.
    What am I going to do with BLOB in a voice based IVR system? I plan to save the voice recording from the caller, then store it into the database via script. Since this is not working, I change my plan of saving the recording to the FTP.

    Thanks,
    HowYee