none
inserting data into tables which are having user defined types using Oracle E Business Adapter RRS feed

  • Question

  • Hi all,

     

    I need to insert in to a table in Oracle DB which is having User defined types as columns .

    when i am generating schemas using add generated items it is generating the type xsd:base64Binary for the user defined type column.how can  i insert data into this column.

     

    following is the error logged in event log

    Event Type: Error
    Event Source: Microsoft Biztalk Adapters for Enterprise Applications
    Event Category: None
    Event ID: 0
    Date:  10/3/2007
    Time:  4:50:38 PM
    User:  N/A
    Computer: SALLTP070345
    Description:
    Error transmitting message: <SOAP-ENV:Fault xmlnsTongue TiedOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>SOAP-ENVTongue Tiederver</faultcode><faultstring>Request ID: Unknown
    Exception Type: System defined exception
    Exception Info:
        Exception occurred:
                Source: OracleApps
                Error Code: 932 (0x3a4)
                Cause: OracleApps://exception=DBException (Unique ID &lt;none&gtWink
            HY000 : [Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected APPS.RAVITEST_TYPE got BINARY


            Exception data:
                struct DBException =
                    WideString StatusCode = "HY000"
                    WideString Description = "[Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected APPS.RAVITEST_TYPE got BINARY
    "</faultstring><detail><exposedBig SmileBException xmlns:exposed="http://schemas.microsoft.com"><exposedTongue TiedtatusCode>HY000</exposedTongue TiedtatusCode><exposedBig Smileescription>[Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected APPS.RAVITEST_TYPE got BINARY
    </exposedBig Smileescription></exposedBig SmileBException></detail></SOAP-ENV:Fault>

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Kindly help me

    Wednesday, October 3, 2007 8:52 PM

All replies

  •  

    Is it possible for you to include more information? For example. Sql Statement to generate the table you are working with. And what are you doing to get above error?

    thanks

    Mukul 

    Saturday, October 27, 2007 1:36 PM