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

    • Moved by Guo Surfer Thursday, March 19, 2009 9:11 AM off topic (Moved from Visual C# General to Off-Topic Posts (Do Not Post Here))
    Monday, March 16, 2009 10:38 AM

All replies