Re: Inserting Wave File [message #45962] |
Mon, 24 October 2005 06:16  |
raval.chintan
Messages: 54 Registered: May 2005
|
Member |
|
|
raval.chintan@gmail.com wrote:
> Dear All,
>
> I am using idl6.2 and Oracle 8i. I want to store and retrive wave file
> data through IDL - Oracle Connectivity. ( Here the Data ,I want to
> store in blob in Oracle) Here i am using IDLDataMiner. Can any body
> help me in that?
>
> Thanks in Advance.
>
> Regards,
> Chintan.
Hi
I am running follwing program. Here i have created one table wavetab in
oracle database which has two fields 1) wavedata 2) id . Here Wavedata
is in blob and id as an integer.
pro inputwave
; Read the Data
data = read_wav('C:\sound1.wav')
;Open Connection Record and Database Record
conn = obj_new('IDLdbDatabase')
staus = DIALOG_DBCONNECT(conn , DATASOURCE='WaveFile')
orec = obj_new('IDLdbRecordSet',conn,TABLE = 'wavetab')
;Add Record
id = 1
orec->AddRecord,[data,id],SET_AUTOINCREMENT=1
; Delete the Record Object
obj_destroy,orec
obj_destroy,conn
end
After running this program when i am running query select count(*) from
wavetab on the sql prompt gives me 0 Row Selected. So This program is
not inserting the data. I will be thankful if any one can help me in
this problem
|
|
|