asp.net - Unsupported Oracle data type USERDEFINED encountered -


sqldatasource chargesds = (sqldatasource)lv2item.findcontrol("charges_gv_datasource"); string sql = "with relevant_ids (select ir.result_id relevant_result_id inspection_result_tbl ir ir.inspection_job_id= '" + incidentid.text + "') select ir.charge_id, collect(ir.result_id) result_ids, ch.charge_progress, ch.claim_verification, ch.hours_allowed, ch.sap_notification, ch.total_checked, ch.charge inspection_result_tbl ir left join relevant_ids on ir.result_id=relevant_ids.relevant_result_id left join charges_tbl ch on ir.charge_id=ch.charge_id ir.charge_id not null group ir.charge_id, ch.charge_progress, ch.claim_verification, ch.hours_allowed, ch.sap_notification, ch.total_checked, ch.charge";                     chargesds.selectcommand = sql; 

i have data source im giving select command shown above giving me error:

unsupported oracle data type userdefined encountered.

with stack trace:

[notsupportedexception: unsupported oracle data type userdefined encountered.]    system.data.oracleclient.oraclecolumn.describe(int32& offset, oracleconnection connection, ocierrorhandle errorhandle) +384881    system.data.oracleclient.oracledatareader.fillcolumninfo() +311    system.data.oracleclient.oracledatareader..ctor(oraclecommand command, ocistatementhandle statementhandle, string statementtext, commandbehavior commandbehavior) +163    system.data.oracleclient.oraclecommand.executereader(commandbehavior behavior) +268    system.data.oracleclient.oraclecommand.executedbdatareader(commandbehavior behavior) +9    system.data.common.dbcommand.system.data.idbcommand.executereader(commandbehavior behavior) +19    system.data.common.dbdataadapter.fillinternal(dataset dataset, datatable[] datatables, int32 startrecord, int32 maxrecords, string srctable, idbcommand command, commandbehavior behavior) +221    system.data.common.dbdataadapter.fill(dataset dataset, int32 startrecord, int32 maxrecords, string srctable, idbcommand command, commandbehavior behavior) +573    system.data.common.dbdataadapter.fill(dataset dataset, string srctable) +161    system.web.ui.webcontrols.sqldatasourceview.executeselect(datasourceselectarguments arguments) +2790902    system.web.ui.datasourceview.select(datasourceselectarguments arguments, datasourceviewselectcallback callback) +27    system.web.ui.webcontrols.databoundcontrol.performselect() +261    bmw.xsapps.rr.partsquality.sandboxpart.sandboxpartusercontrol.setchargesgv() +891    bmw.xsapps.rr.partsquality.sandboxpart.sandboxpartusercontrol.populatepage(boolean filteractive) +5827    bmw.xsapps.rr.partsquality.sandboxpart.sandboxpartusercontrol.page_load(object sender, eventargs e) +1310    system.web.util.callihelper.eventargfunctioncaller(intptr fp, object o, object t, eventargs e) +25    system.web.util.callieventhandlerdelegateproxy.callback(object sender, eventargs e) +42    system.web.ui.control.onload(eventargs e) +132    system.web.ui.control.loadrecursive() +66    system.web.ui.control.addedcontrol(control control, int32 index) +350    bmw.xsapps.rr.partsquality.sandboxpart.sandboxpart.createchildcontrols() +155    system.web.ui.control.ensurechildcontrols() +146    system.web.ui.control.prerenderrecursiveinternal() +61    system.web.ui.control.prerenderrecursiveinternal() +224    system.web.ui.control.prerenderrecursiveinternal() +224    system.web.ui.control.prerenderrecursiveinternal() +224    system.web.ui.control.prerenderrecursiveinternal() +224    system.web.ui.control.prerenderrecursiveinternal() +224    system.web.ui.page.processrequestmain(boolean includestagesbeforeasyncpoint, boolean includestagesafterasyncpoint) +3394 

any ideas on how fix error? think it's collect part.

thanks.

i fixed replacing

using system.data.oracleclient;

with

using oracle.dataaccess.client; 

you have add reference above change: oracle.dataaccess


Comments

Popular posts from this blog

c++ - Creating new partition disk winapi -

Android Prevent Bluetooth Pairing Dialog -

VBA function to include CDATA -