CRA 3.1(1) script - Inserting a voice message in a DB

[laurentberwaerts]

Hi,

I'm using CRA 3.1(1) and I try to insert a voice message in an oracle database using ODBC.

The voice message (a G.729a wave file) is a com.cisco.doc.Document type that corresponds to an Oracle BLOB field.

I achieved to retrieve such a wave file from the DB but I cannot insert it again as a new row using the following statement:

INSERT INTO prompttest(pk_id,namechar,theprompt,thetime)

VALUES(seq_VM_ID.NEXTVAL,$strPromptName,$oPrompt,$dtDate)

When I take a look into the log file, I see an error: parameter null. But when I debug the script, all the parameters have a value.

The prompt is not null since I can play it out.

Could anybody help me out with this problem?

Thanks,

Laurent.

[adignan]

Just a thought but its what I have done in the past is to save the recorded file to disk and then save the locations/.wav file name in the DB. Then, to play the .wav you just query the DB for the location of the file, and use the play prompt to play your .wav file.

andy - berbee