Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
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
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