none
ODP.NET WITH ORACLE UDT TYPES : SCHEMANAME='TEST_API' TYPENAME='COUNT'' IS NOT SPECIFIED OR IS INVALID. RRS feed

  • Question

  • 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

    Tuesday, March 17, 2009 10:22 AM

Answers

  • You probably need to ask this question on an Oracle forum. On this forum we discuss problems related to Xml on .NET Framework.

    Pawel

    Tuesday, March 17, 2009 4:27 PM
    Moderator