Unsupported Oracle Data Type userdefined encountered Solution

System. notsupportedexception: Unsupported
Oracle Data Type userdefined encountered

It turns out that the table structure of the Oracle database called by Web Service contains the Oracle Spatial Field, so it cannot be returned correctly.

Solution: vertical decomposition and horizontal comparison.

It is concluded by comparing it with other tables with simple fields.

-----------------------------------------

 
[Webmethod]// Dataset can be returned, but the returned datatable is more complex. Added by zhangjun

Public Dataset
Doqueryex (string sqlstr)

{

If (string. isnullorempty (sqlstr ))

{

Return
NULL;

}

Dataset result = new dataset ();

Using (oracleconnection
Conn = new oracleconnection (_ connstr ))

{

Try

{

If
(Conn. State = connectionstate. Closed)

{

Conn. open ();

}

Oracledataadapter
Adapter = new oracledataadapter (sqlstr,
Conn );

Adapter. Fill (result );// Either fill dataset or fill datatable

Adapter. Dispose ();

Return
Result;

}

Catch
(Exception ex)

{

Throw
Ex;

}

}

}