Blogs

Showing 0 results.

Forums

« Back to Contact Center Express Scripting Questions

Oracle database - unsupported type

Combination View Flat View Tree View
Threads [ Previous | Next ]
Oracle database - unsupported type
ccx web services integration database oracle unsupported type
Answer
12/13/11 4:32 PM
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
Attachments:
Flag

RE: Oracle database - unsupported type
Answer
2/24/12 3:25 PM as a reply to Na How Yee.
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.
Flag

RE: Oracle database - unsupported type
Answer
2/27/12 2:26 AM as a reply to Steven Pawlak.
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
Flag