Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

hbayramApr 26 2013 — edited Apr 26 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2013

Added on Apr 26 2013

#heterogeneous-connectivity, #service

3 comments

2,112 views