In the use of C # code to get data from Oracle database, but because it is an object-oriented way, the model object in C # is also established in Oracle, and the corresponding mapping should be done in the Oracle connection code of C #.
When running, this exception is thrown:
ex=System.InvalidOperationException: Custom type mapping not specified with 'dataSource='xxxxxxx' schemaName='xxx' typeName='xxx' or the mapping is invalid
at Oracle.DataAccess.Types.OracleUdt.GetFactory(OracleUdtDescriptor udtDesc)
at Oracle.DataAccess.Client.OracleParameter.SetUDTFromArray(OracleConnection conn, Object array, Int32 i)
at Oracle.DataAccess.Client.OracleParameter.PreBind_Collection(OracleConnection conn)
at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn, IntPtr errCtx, Int32 arraySize)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at HCC.Base.Comm.Dao.OraHelper.ExecuteDataTableSp(String dbkey, String procName, List`1 prams)
Through various searches, it is found that the source of the problem lies in accidentally writing the udttypename wrong in the mapping code, which leads to this exception. Correct the spelling of udttypename to make the code work properly.
Read More:
- [Solved] System.InvalidOperationException: Failed to deploy distro docker-desktop……
- How to Solve Error: Missing type map configuration or unsupported mapping
- The method println(boolean) in the type PrintStream is not applicable for the arguments (void) Error
- [Solved] MongoDB Error: TypeError: Object of type ObjectId is not JSON serializable
- AUC Error – ValueError: Data is not binary and pos_label is not specified
- [Solved] MindSpore Error: Data type conversion of ‘Parameter’ is not supporte
- [Solved] Go Get Download Dependency Error: is not using a known version control system
- Error response from daemon: driver failed programming external connectivity on endpoint quirky_allen is reported when docker port mapping or starting the container
- std::dynamic_pointer_cast Error: source type is not polymorphic
- [Solved] The type or namespace name ‘Service’ does not exist Error
- VUE: Property or method “deleteFun“ is not defined on the instance but referenced during render. [How to Fix]
- Readiness probe failed: calico/node is not ready: BIRD is not ready: Error querying BIRD: unable to
- [Solved] Canoe CAPL Error: “the test module is not assigned or invalid”
- [Solved] Idea 2020 uses SVN error: ‘C: \ program’ is not an internal or external command
- Tensorflow Run Error or the interface is stuck or report error: Could not create cudnn handle: CUDNN_STATUS_INTERNAL_ERROR
- The browser is compatible with IE11 “ReferenceError: ‘Promise’ is not defined” “ReferenceError: ‘Promise’ is not defined”
- [Solved] This is probably not a problem with npm. There is likely additional logging output above.
- [Solved] IDEA Start Project Error: Abnormal build process termination:Could not create the Java Virtual Machine.
- Puppeteer Error: Chromium revision is not downloaded. Run “npm install“ or “yarn install“
- [Solved] (error) MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk.