3 Replies Latest reply on Apr 26, 2013 1:35 PM by Mkirtley-Oracle

    ORA-02070: database does not support insert values in this context

    hbayram
      Hi,
      I have configured a Heterogeneous service on linux oracle for mysql database. I can select from any mysql table through the service. But when I try to insert into a table I get the error below.
      ORA-02070: database SERVICE_NAME does not support insert values in this context


      configuration is below:
      [oracle@plantumweb admin]$ pwd
      /products/oracle/product/11.2.0/hs/admin

      [oracle@plantumweb admin]$ more initmerkezdb.ora
      # This is a sample agent init file that contains the HS parameters that are
      # needed for the Database Gateway for ODBC
      ##
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO=merkezdb
      HS_FDS_TRACE_LEVEL=debug
      HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
      #HS_FDS_SQLLEN_INTERPRETATION=32
      HS_FDS_FETCh_ROWS=1
      HS_NLS_NCHAR = UCS2
      HS_FDS_TRACE_LEVEL = ON
      HS_FDS_TRACE_LEVEL = 255
      HS_TRANSACTION_MODEL = READ_ONLY
      HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
      #
      # ODBC specific environment variables
      #
      set ODBCINI=/etc/odbc.ini

      #
      # Environment variables required for the non-Oracle system
      #


      is it a configuration issue or another problem. Please help me.
      thank you.

      Edited by: 1002692 on 26.Nis.2013 01:47