i using oracle db , calling simple select query oracle throwing weird error message:
a first chance exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll unspecified error oracle error occurred, error message not retrieved oracle. data type not supported.
this how calling:
cdb conn = new cdb(); conn.getconnection(); system.data.oledb.oledbdatareader reader = null; string query = "select * table"; reader = conn.find(query); while (reader.read()) { console.writeline("going..."); } on debugging thorws exception after printing above mentioned error message. doing wrong?
database schema:
sb_id not null number(11) sb_title varchar2(200) sb_ondate timestamp(0) sb_rcvddate_qamri varchar2(10) sb_rcvddate_shamsi date sb_mode number(1) sb_preference number(1) sb_status number(1) sb_raseed_issued number(1) sb_mujib_id number(11) sb_recvd_by_id number(11) sb_mustafti_fullname varchar2(100) sb_mustafti_address varchar2(100) sb_mustafti_country number(3) sb_mustafti_city varchar2(100) sb_mustafti_state varchar2(100) sb_mustafti_mobile varchar2(20) sb_mustafti_phone varchar2(20) sb_mustafti_fax varchar2(20) sb_mustafti_email varchar2(40) sb_mustafti_nic varchar2(20) sb_distribution_date date sb_issuedate_qamri varchar2(10) sb_issuedate_shamsi date
the potentially troublesome datatype in posted schema timestamp according docs supported ole db 10g. find out more.
so, either you're not using modern version of ole db, or there more obscure problem table. tiresome foolproof way of debugging specify column names in query , find 1 doesn't like.
Comments
Post a Comment