Dear All,
I'm working on ODP.net with C#.net 2005, using user-defined data types as input and output parameters to a function. while executing my function in server it's showing an error like this.
Exception At ExecuteNonQuery(), Error = System.InvalidOperationException: Custom
type mapping for 'dataSource='(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST =
10.0.2.3) (PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =
ORCLTD)))' schemaName='Test_API' typeName='COUNT'' is not specified o
r is invalid.
at Oracle.DataAccess.Types.OracleUdt.GetFactory(OracleUdtDescriptor udtDesc)
at Oracle.DataAccess.Client.OracleParameter.SetUDTFromCustomObject(OracleConn
ection conn, IOracleCustomType customObj, Int32 i)
at Oracle.DataAccess.Client.OracleParameter.PreBind_OracleObject(OracleConnec
tion conn)
at Oracle.DataAccess.Client.OracleParameter.PreBind_Object(OracleConnection c
onn)
at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn, In
tPtr errCtx, Int32 arraySize)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
As i don't know about 'Test_API' which is in the server, but COUNT is user defined data type.
Actually i changed the user id code for OracleCustomTypeMappingAttribute in auto-generated code in Oracle custom class.
changed from
OracleCustomTypeMappingAttribute("SCOTT.COUNT")
to
OracleCustomTypeMappingAttribute("MAINDB.COUNT").
what is the relation between SCHEMANAME and TYPENAME.
pls help.
Ideas are highly appreciated.
Anil