Dear Friends ,
I have to configure Oracle Gateway server successfully between oracle11g database and sql2012 database . And also I can copy data from sql2012 to oracle database successfully .
SQL> copy from ultimus/ultimus@dvlpmnt insert cor_trans_client@dg4msql using select * from cor_trans_client
commit;
Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
1415 rows selected from ultimus@dvlpmnt.
1415 rows inserted into COR_TRANS_CLIENT@DG4MSQL.
1415 rows committed into COR_TRANS_CLIENT@DG4MSQL at DEFAULT HOST connection.
SQL>
Commit complete.
>> But some of the tables I cannot copy data , it shows the below error :
--
SQL> copy from ultimus/ultimus@dvlpmnt insert rtl_scheme_ac_mast@dg4msql using select * from rtl_scheme_ac_mast
Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]Invalid parameter number {07009}
ORA-02063: preceding 2 lines from DG4MSQL
---
Would anybody help me to resolve this issue ?
--
[oracle@gateway ~]$ cat /u01/app/oracle/gateway/dg4msql/admin/initdg4msql.ora
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server
#
# HS init parameters
#
#HS_FDS_CONNECT_INFO=[192.168.1.62]:51792//Card
HS_FDS_CONNECT_INFO=[192.168.1.62]:1433//ULTIMUS_CONV
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
#HS_RPC_FETCH_REBLOCKING= OFF
#HS_FDS_FETCH_ROWS = 1
---