| 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
|
|
|
|
| Re: Inserting Wave File [message #46041 is a reply to message #45962] |
Mon, 24 October 2005 23:29  |
raval.chintan
Messages: 54
Registered: May 2005
|
Member |
|
|
raval.chintan@gmail.com wrote:
> 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
Hi,
Does any one has example of adding image as an blob object in to sql
and oracle database using dataminer with IDL?
Regards
Chintan
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
