Immuctzismili
New Member
I am trying to do an insert from a file to the oracle database. i've mainly folllowed the tutorial i found here. I've done some minor changes to make it an Insert only though, but the Insert sent port picks up the file now but gives the below error.What could be wrong here or is there a way to check what query is created by this interface?Input file\[code\]<ns0:Insert xmlns:ns0="http://Microsoft.LobServices.OracleDB/2007/03/DCSDBA/Table/V_SIZE"> <ns0:RECORDSET> <ns0:V_SIZERECORDINSERT> <ns0:V_SIZE InlineValue="http://stackoverflow.com/questions/11240687/InlineValue_0">V_SIZE_0</ns0:V_SIZE> <ns0:SEQ_NR InlineValue="http://stackoverflow.com/questions/11240687/InlineValue_0">10.4</ns0:SEQ_NR> </ns0:V_SIZERECORDINSERT> </ns0:RECORDSET></ns0:Insert>\[/code\]Error message\[code\]The adapter failed to transmit message going to send port "WcfSendPort_OracleDBBinding_DCSDBA_Table_V_SIZE_Custom" with URL "oracledb://redprairie:1521/TST/Dedicated?PollingId=Test". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-06550: line 2, column 78
L/SQL: ORA-00984: column not allowed hereORA-06550: line 2, column 1L/SQL: SQL Statement ignored ---> Oracle.DataAccess.Client.OracleException: ORA-06550: line 2, column 78L/SQL: ORA-00984: column not allowed hereORA-06550: line 2, column 1L/SQL: SQL Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper) --- End of inner exception stack trace ---\[/code\]
L/SQL: ORA-00984: column not allowed hereORA-06550: line 2, column 1L/SQL: SQL Statement ignored ---> Oracle.DataAccess.Client.OracleException: ORA-06550: line 2, column 78L/SQL: ORA-00984: column not allowed hereORA-06550: line 2, column 1L/SQL: SQL Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper) --- End of inner exception stack trace ---\[/code\]