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
Post a Comment