11 Replies Latest reply: May 23, 2013 10:51 AM by ZGibson_BZ RSS

    Database Link Error to MySQL when using variables

    ZGibson_BZ
      Hi Guys

      I currently hava a database link to MySQL. I can read, insert, delete and update with no problems when using literals. However when I attempt to carry out the same actions using pl/sql variables I recieve the following error:

      ORA-02055: distributed update operation failed; rollback required
      ORA-02068: following severe error from AAA1
      ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ProdDB.btl.net)(PORT=1527))(CONNECT_DATA=(SID=AAA1)))
      ORA-06512: at line 15

      Could you kindly give me some suggestions?


      PL/SQL Code

      Declare

      MSISDN2 char(8);
      IMSI2 number(28,0);
      ICC2 number(28,0);
      cnt number(28,0);

      Begin

      MSISDN2 :='610-0850';
      IMSI2:=8950167090300132451;
      ICC2:=702670161017765;


      delete from "SUBSCRIBERS"@AAA1 where "MSISDN" = MSISDN2;--"ICC" = ICC2 or "IMSI" = IMSI2;

      End;


      -----------------------------------------------------------------------------------------------------------
      System Info:

      Oracle Database 10.2.0.5.0 on Redhat Linux 64 bit

      Oracle Database Gateways for ODBC 11.2.0.1.0 on same machine as above

      UnixODBC-3.2.1 compiled in 64bit mode on same machine as well

      MySQL ODBC Connector DriverVer:05.02.0002

      ------------------------------------------------------------------------------------------------------
      ODBC DSN

      ;
      ; odbc.ini configuration for Connector/ODBC and Connector/ODBC 3.51 drivers
      ;

      [ODBC Data Sources]
      AAA1 = MyODBC 5.2.2 Driver DSN

      [AAA1]
      Driver = /usr/lib64/libmyodbc5w.so
      Description = Connector/ODBC 5.52 Driver DSN
      SERVER = 10.50.18.89
      USER = tytancc2
      Password = xxxxxx
      Database = radiator
      OPTION = 3
      CHARSET = latin1
      Trace = yes
      TraceFile = /tmp/unixodbc.sql.log
      Debug = 1
      Debugfile = /tmp/unixodbc.debug.log

      ---------------------------------------------------------------------------------------
      HS File
      # 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 = AAA1
      #HS_FDS_TRACE_LEVEL = 255
      HS_FDS_TRACE_LEVEL = DEBUG
      #HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5w.so
      HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so.2
      HS_FDS_SQLLEN_INTERPRETATION=32
      #HS_LANGUAGE = AMERICAN_AMERICA.AL32UTF8
      #HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15
      #HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
      HS_LANGUAGE = AMERICAN_AMERICA.LATIN1
      HS_FDS_FETCH_ROWS=1
      #HS_NLS_NCHAR= UCS2
      #HS_OPEN_CURSORS=10


      #
      # ODBC specific environment variables
      #
      set ODBCINI=/u01/oracle/.odbc.ini
      set ODBCINSTINI=/etc/odbcinst.ini


      #
      # Environment variables required for the non-Oracle system
      #
      set LD_LIBRARY_PATH=/usr/lib64


      --------------------------------------------------------------------------------------------
      Trace File

      Oracle Corporation --- FRIDAY FEB 08 2013 22:01:40.555


      Heterogeneous Agent Release
      11.2.0.1.0




      Oracle Corporation --- FRIDAY FEB 08 2013 22:01:40.549

      Version 11.2.0.1.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
      Entered hgosdip
      setting HS_OPEN_CURSORS to default of 50
      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
      setting HS_FDS_RECOVERY_PWD to default value
      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
      setting HS_IDLE_TIMEOUT to default of 0
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "AL32UTF8"
      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
      setting HS_FDS_DATE_MAPPING to default of "DATE"
      setting HS_RPC_FETCH_REBLOCKING to default of "ON"
      HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
      setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
      setting HS_FDS_MAP_NCHAR to default of "TRUE"
      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
      setting HS_FDS_QUERY_DRIVER to default of "TRUE"
      setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
      Parameter HS_FDS_QUOTE_IDENTIFIER is not set
      setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
      HOSGIP returned value of "32" for HS_FDS_SQLLEN_INTERPRETATION
      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
      setting HS_FDS_DELAYED_OPEN to default of "TRUE"
      setting HS_FDS_WORKAROUNDS to default of "0"
      Exiting hgosdip, rc=0
      ORACLE_SID is "AAA1"
      Product-Info:
      Port Rls/Upd:1/0 PrdStat:0
      Agent:Oracle Database Gateway for ODBC
      Facility:hsa
      Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:AAA1
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=31
      HOCXU_DRV_NCHAR=873
      HOCXU_DB_CSET=31
      HOCXU_SEM_VER=102000
      Entered hgolofn at 2013/02/08-22:01:40
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so.2"
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a08f61
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a090e5
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a09c18
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a0b6dc
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a17bc4
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a182e8
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a1bc40
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a1dad8
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a1e6dc
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a20bae
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a20bd0
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a22f44
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a276d4
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a27b90
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2a4a4
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2b574
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2b99c
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2e65c
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2ecd0
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a31db8
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a31ac0
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a0c47c
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a0e884
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a14943
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a1714a
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a19327
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a1d2ce
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a1f648
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a210c7
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a23990
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2414c
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a25d26
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a26cc0
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a288a8
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a28c67
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a29e88
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2c51e
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2ccfa
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2d5c0
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2de92
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a2f088
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a33fa4
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a315fe
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a36de2
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Entered hgolofns at 2013/02/08-22:01:40
      symbol_peflctx=0x31a380ec
      hoaerr:0
      Exiting hgolofns at 2013/02/08-22:01:40
      Exiting hgolofn, rc=0 at 2013/02/08-22:01:40
      HOSGIP for "HS_OPEN_CURSORS" returned "50"
      HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
      treat_SQLLEN_as_compiled = 0
      Exiting hgoinit, rc=0 at 2013/02/08-22:01:40
      Entered hgolgon at 2013/02/08-22:01:40
      reco:0, name:tytancc2, tflag:0
      Entered hgosuec at 2013/02/08-22:01:40
      Exiting hgosuec, rc=0 at 2013/02/08-22:01:40
      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
      using tytancc2 as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2013/02/08-22:01:40
      HS_FDS_CONNECT_INFO = "AAA1"
      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
      Entered hgogenconstr at 2013/02/08-22:01:40
      dsn:AAA1, name:tytancc2
      optn:
      Entered hgocip at 2013/02/08-22:01:40
      dsn:AAA1
      Exiting hgocip, rc=0 at 2013/02/08-22:01:40
      Exiting hgogenconstr, rc=0 at 2013/02/08-22:01:40
      Entered hgolosf at 2013/02/08-22:01:45
      Exiting hgolosf, rc=0 at 2013/02/08-22:01:45
      DriverName:libmyodbc5w.so, DriverVer:05.02.0002
      DBMS Name:MySQL, DBMS Version:5.1.66-community-log
      Exiting hgocont, rc=0 at 2013/02/08-22:01:45
      SQLGetInfo returns Y for SQL_CATALOG_NAME
      SQLGetInfo returns 192 for SQL_MAX_CATALOG_NAME_LEN
      Exiting hgolgon, rc=0 at 2013/02/08-22:01:45
      Entered hgoulcp at 2013/02/08-22:01:45
      Entered hgowlst at 2013/02/08-22:01:45
      Exiting hgowlst, rc=0 at 2013/02/08-22:01:45
      SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
      TXN Capable:3, Isolation Option:0xf
      SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
      SQLGetInfo returns 192 for SQL_MAX_TABLE_NAME_LEN
      SQLGetInfo returns 192 for SQL_MAX_PROCEDURE_NAME_LEN
      SQLGetInfo returns ` (0x60) for SQL_IDENTIFIER_QUOTE_CHAR
      SQLGetInfo returns Y for SQL_COLUMN_ALIAS
      16 instance capabilities will be uploaded
      capno:1964, context:0x00000000, add-info: 0
      capno:1989, context:0x00000000, add-info: 0
      capno:1991, context:0x0001ffff, add-info: 0
      capno:1992, context:0x0001ffff, add-info: 1, translation:"`"
      capno:3042, context:0x00000000, add-info: 0, translation:"42"
      capno:3047, context:0x00000000, add-info: 0, translation:"57"
      capno:3049, context:0x00000000, add-info: 0, translation:"59"
      capno:3050, context:0x00000000, add-info: 0, translation:"60"
      capno:3066, context:0x00000000, add-info: 0
      capno:3067, context:0x00000000, add-info: 0
      capno:3068, context:0x00000000, add-info: 0
      capno:3069, context:0x00000000, add-info: 0
      capno:3500, context:0x00000001, add-info: 91, translation:"42"
      capno:3501, context:0x00000001, add-info: 93, translation:"57"
      capno:3502, context:0x00000001, add-info: 107, translation:"59"
      capno:3503, context:0x00000001, add-info: 110, translation:"60"
      Exiting hgoulcp, rc=0 at 2013/02/08-22:01:45
      Entered hgouldt at 2013/02/08-22:01:45
      NO instance DD translations were uploaded
      Exiting hgouldt, rc=0 at 2013/02/08-22:01:45
      Entered hgobegn at 2013/02/08-22:01:45
      tflag:0 , initial:1
      hoi:0x9671a48, ttid (len 26) is ...
      00: 54595441 4E2E6438 32323564 62642E32 [TYTAN.d8225dbd.2]
      10: 392E372E 33313031 3433 [9.7.310143]
      tbid (len 10) is ...
      0: 1D000700 7FBB0400 0104 [..........]
      Exiting hgobegn, rc=0 at 2013/02/08-22:01:45
      Entered hgopdsc at 2013/02/08-22:01:45
      Describing procedure SUBSCRIBERS
      Output hoada
      hgopdsc, line 1406: NO hoada to print
      Exiting hgopdsc, rc=942 at 2013/02/08-22:01:45
      Entered hgodtab at 2013/02/08-22:01:45
      count:1
      table: SUBSCRIBERS
      Allocate hoada[0] @ 0x3a23590
      Entered hgopcda at 2013/02/08-22:01:45
      Column:1(MSISDN): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:2(IMSI): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:3(ICC): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:4(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:5(REPLYATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:6(TIMELEFT): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:7(ELIMINATED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:8(SUSPENDED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      The hoada for table SUBSCRIBERS follows...
      hgodtab, line 876: Printing hoada @ 0x3a23590
      MAX:8, ACTUAL:8, BRC:1, WHT=6 (TABLE_DESCRIBE)
      hoadaMOD bit-values found (0x200:TREAT_AS_CHAR,0x20:NEGATIVE_HOADADTY)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      1 CHAR N 8 8 0/ 0 0 0 200 MSISDN
      -5 BIGINT N 8 8 0/ 0 0 0 20 IMSI
      -5 BIGINT N 8 8 0/ 0 0 0 20 ICC
      1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
      1 CHAR Y 200 200 0/ 0 0 0 200 REPLYATTR
      -5 BIGINT Y 8 8 0/ 0 0 0 20 TIMELEFT
      -5 BIGINT Y 8 8 0/ 0 0 0 20 ELIMINATED
      -5 BIGINT Y 8 8 0/ 0 0 0 20 SUSPENDED
      Exiting hgodtab, rc=0 at 2013/02/08-22:01:45
      Entered hgodafr, cursor id 0 at 2013/02/08-22:01:45
      Free hoada @ 0x3a23590
      Exiting hgodafr, rc=0 at 2013/02/08-22:01:45
      Entered hgopars, cursor id 1 at 2013/02/08-22:01:45
      type:0
      SQL text from hgopars, id=1, len=134 ...
      00: 53454C45 43542041 312E604D 53495344 [SELECT A1.`MSISD]
      10: 4E602C41 312E6049 4D534960 2C41312E [N`,A1.`IMSI`,A1.]
      20: 60494343 602C4131 2E604348 45434B41 [`ICC`,A1.`CHECKA]
      30: 54545260 2C41312E 60524550 4C594154 [TTR`,A1.`REPLYAT]
      40: 5452602C 41312E60 54494D45 4C454654 [TR`,A1.`TIMELEFT]
      50: 602C4131 2E60454C 494D494E 41544544 [`,A1.`ELIMINATED]
      60: 602C4131 2E605355 5350454E 44454460 [`,A1.`SUSPENDED`]
      70: 2046524F 4D206053 55425343 52494245 [ FROM `SUBSCRIBE]
      80: 52536020 4131 [RS` A1]
      Exiting hgopars, rc=0 at 2013/02/08-22:01:45
      Entered hgoopen, cursor id 1 at 2013/02/08-22:01:45
      hgoopen, line 86: NO hoada to print
      Deferred open until first fetch.
      Exiting hgoopen, rc=0 at 2013/02/08-22:01:45
      Entered hgodscr, cursor id 1 at 2013/02/08-22:01:45
      Allocate hoada @ 0x3a23538
      Entered hgopcda at 2013/02/08-22:01:45
      Column:1(MSISDN): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:2(IMSI): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:3(ICC): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:4(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:5(REPLYATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:6(TIMELEFT): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:7(ELIMINATED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      Entered hgopcda at 2013/02/08-22:01:45
      Column:8(SUSPENDED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
      hgodscr, line 880: Printing hoada @ 0x3a23538
      MAX:8, ACTUAL:8, BRC:1, WHT=5 (SELECT_LIST)
      hoadaMOD bit-values found (0x200:TREAT_AS_CHAR,0x20:NEGATIVE_HOADADTY)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      1 CHAR N 8 8 0/ 0 0 0 200 MSISDN
      -5 BIGINT N 8 8 0/ 0 0 0 20 IMSI
      -5 BIGINT N 8 8 0/ 0 0 0 20 ICC
      1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
      1 CHAR Y 200 200 0/ 0 0 0 200 REPLYATTR
      -5 BIGINT Y 8 8 0/ 0 0 0 20 TIMELEFT
      -5 BIGINT Y 8 8 0/ 0 0 0 20 ELIMINATED
      -5 BIGINT Y 8 8 0/ 0 0 0 20 SUSPENDED
      Exiting hgodscr, rc=0 at 2013/02/08-22:01:45
      Entered hgoclse, cursor id 1 at 2013/02/08-22:01:46
      Exiting hgoclse, rc=0 at 2013/02/08-22:01:46
      Entered hgodafr, cursor id 1 at 2013/02/08-22:01:46
      Free hoada @ 0x3a23538
      Exiting hgodafr, rc=0 at 2013/02/08-22:01:46
      Entered hgopars, cursor id 1 at 2013/02/08-22:01:46
      type:0
      SQL text from hgopars, id=1, len=56 ...
      00: 44454C45 54452046 524F4D20 60535542 [DELETE FROM `SUB]
      10: 53435249 42455253 60205748 45524520 [SCRIBERS` WHERE ]
      20: 60535542 53435249 42455253 602E604D [`SUBSCRIBERS`.`M]
      30: 53495344 4E603D3F [SISDN`=?]
      Exiting hgopars, rc=0 at 2013/02/08-22:01:46
      Entered hgoexec, cursor id 1 at 2013/02/08-22:01:46
      octype=3 (DELETE)
      hgoexec, line 108: Printing hoada @ 0x3a23538
      MAX:1, ACTUAL:1, BRC:1, WHT=3 (BIND_LIST)
      hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      1 CHAR N 8 0 0/ 0 31 0 200 ?
      Entered hgoprbv at 2013/02/08-22:01:46
      hgoprbv, line 145: Printing hoada @ 0x3a23538
      MAX:1, ACTUAL:1, BRC:1, WHT=3 (BIND_LIST)
      hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      1 CHAR N 8 0 0/ 0 31 0 200 ?
      Exiting hgoprbv, rc=0 at 2013/02/08-22:01:46
        • 1. Re: Database Link Error to MySQL when using variables
          Kgronau-Oracle
          Could you please post the table definition of the MySQL table as it is defined in the MySQL database and how it is described using the database link (desc "SUBSCRIBERS"@AAA1)
          What happens when you comment out the gateway init parameter:
          HS_FDS_SQLLEN_INTERPRETATION=32 ?


          Thanks,
          Klaus

          Edited by: kgronau on Feb 11, 2013 7:37 AM

          Just successfully tested DG4ODBC 11.2.0.3 by defining a table in MySQL:
          drop table SUBSCRIBERS;
          create table SUBSCRIBERS (MSISDN char(8),IMSI2 numeric(28,0), ICC2 numeric(28,0), cnt numeric(28,0));
          insert into SUBSCRIBERS values('610-0850', 8950167090300132451, 702670161017765,NULL);


          and using this code:
          SQL> select count(*) from "SUBSCRIBERS"@MYSQL_DG4ODBC_EMGTW_1123_DB;

          COUNT(*)
          ----------
          1

          SQL> Declare
          2
          3 MSISDN2 char(8);
          4 IMSI2 number(28,0);
          5 ICC2 number(28,0);
          6 cnt number(28,0);
          7
          8 Begin

          9 10 MSISDN2 :='610-0850';
          11 IMSI2:=8950167090300132451;
          12 ICC2:=702670161017765;
          13
          14 delete from "SUBSCRIBERS"@MYSQL_DG4ODBC_EMGTW_1123_DB where "MSISDN" = MSISDN2;
          15 --"ICC" = ICC2 or "IMSI" = IMSI2;
          16
          17 End;
          18 /

          PL/SQL procedure successfully completed.

          SQL> select count(*) from "SUBSCRIBERS"@MYSQL_DG4ODBC_EMGTW_1123_DB;

          COUNT(*)
          ----------
          0

          Edited by: kgronau on Feb 11, 2013 7:51 AM

          Also successfully tested using DG4ODBC 11.2.0.1 and 10.2.0.5 Oracle database
          • 2. Re: Database Link Error to MySQL when using variables
            ZGibson_BZ
            Hi Klaus,

            Thanks, that did the trick for the inserts and deletes. I think the reason I had set HS_FDS_SQLLEN_INTERPRETATION to 32 was because the MySQL database was 32 bit. The one issue I now have is that when selecting I cannot retrieve columns that have Null value which had previously worked with interpretation set to 64. I'm fine with proceeding like this but was just wondering if you had any input?

            Thanks once again,
            Zane

            Error:

            select "MSISDN","ICC","IMSI","CHECKATTR","REPLYATTR","TIMELEFT","SUSPENDED","ELIMINATED" from "SUBSCRIBERS"@AAA1

            ORA-28528: Heterogeneous Services datatype conversion error
            ORA-02063: preceding line from AAA1

            Null fields are "CHECKATTR","REPLYATTR","TIMELEFT". SQL runs fine when removing these.


            Table Description from SQLPlus


            SQL> desc "SUBSCRIBERS"@AAA1;

            Name| Null?| Type

            MSISDN| NOT NULL| CHAR(8)
            IMSI| NOT NULL| NUMBER(20)
            ICC| NOT NULL| NUMBER(20)
            CHECKATTR| | CHAR(200)
            REPLYATTR| | CHAR(200)
            TIMELEFT| | NUMBER(20)
            ELIMINATED| | NUMBER(20)
            SUSPENDED| | NUMBER(20)


            *sorrry not sure why the spaces are not being displayed so separated the fields by "|"

            Edited by: ZGibson_BZ on Feb 11, 2013 3:33 PM
            • 3. Re: Database Link Error to MySQL when using variables
              Mkirtley-Oracle
              Hi,
              You say removing the "CHECKATTR","REPLYATTR","TIMELEFT" columns allows the SQL to run but does it also run if you leave the "SUSPENDED","ELIMINATED" columns in the SQL because these can also be 'NULL' according to the describe. Or is it only a problem if a column contains null data so that "SUSPENDED","ELIMINATED" have actual values and so do not give the problem ?
              Could you post a gateway trace from running a select of only one of the columns that gives the error, for example CHECKATTR ?

              Regards,
              Mike

              Edited by: mkirtley on Feb 12, 2013 11:26 AM
              • 4. Re: Database Link Error to MySQL when using variables
                ZGibson_BZ
                Hi Mike,

                That is correct, ELIMINATED and SUSPENDED fields are never null. Please find trace below when I run the SQL Select "CHECKATTR" from "SUBSCRIBERS"@AAA1;

                Thanks,
                Zane




                Oracle Corporation --- TUESDAY FEB 12 2013 08:18:15.982


                Heterogeneous Agent Release
                11.2.0.1.0




                Oracle Corporation --- TUESDAY FEB 12 2013 08:18:15.977

                Version 11.2.0.1.0

                Entered hgogprd
                HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
                Entered hgosdip
                setting HS_OPEN_CURSORS to default of 50
                setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
                setting HS_FDS_RECOVERY_PWD to default value
                setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
                setting HS_IDLE_TIMEOUT to default of 0
                setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
                setting HS_NLS_NCHAR to default of "AL32UTF8"
                setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
                setting HS_FDS_DATE_MAPPING to default of "DATE"
                setting HS_RPC_FETCH_REBLOCKING to default of "ON"
                HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
                setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
                setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
                setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
                setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
                setting HS_FDS_MAP_NCHAR to default of "TRUE"
                setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
                setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
                setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
                setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
                setting HS_FDS_QUERY_DRIVER to default of "TRUE"
                setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
                Parameter HS_FDS_QUOTE_IDENTIFIER is not set
                setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
                setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
                setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
                HOSGIP returned value of "64" for HS_FDS_SQLLEN_INTERPRETATION
                setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
                setting HS_FDS_DELAYED_OPEN to default of "TRUE"
                setting HS_FDS_WORKAROUNDS to default of "0"
                Exiting hgosdip, rc=0
                ORACLE_SID is "AAA1"
                Product-Info:
                Port Rls/Upd:1/0 PrdStat:0
                Agent:Oracle Database Gateway for ODBC
                Facility:hsa
                Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:AAA1
                Exiting hgogprd, rc=0
                Entered hgoinit
                HOCXU_COMP_CSET=1
                HOCXU_DRV_CSET=31
                HOCXU_DRV_NCHAR=873
                HOCXU_DB_CSET=31
                HOCXU_SEM_VER=102000
                Entered hgolofn at 2013/02/12-08:18:16
                HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so.2"
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a08f61
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a090e5
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a09c18
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a0b6dc
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a17bc4
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a182e8
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a1bc40
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a1dad8
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a1e6dc
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a20bae
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a20bd0
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a22f44
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a276d4
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a27b90
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2a4a4
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2b574
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2b99c
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2e65c
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2ecd0
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a31db8
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a31ac0
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a0c47c
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a0e884
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a14943
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a1714a
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a19327
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a1d2ce
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a1f648
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a210c7
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a23990
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2414c
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a25d26
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a26cc0
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a288a8
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a28c67
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a29e88
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2c51e
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2ccfa
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2d5c0
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2de92
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a2f088
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a33fa4
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a315fe
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a36de2
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Entered hgolofns at 2013/02/12-08:18:16
                symbol_peflctx=0x31a380ec
                hoaerr:0
                Exiting hgolofns at 2013/02/12-08:18:16
                Exiting hgolofn, rc=0 at 2013/02/12-08:18:16
                HOSGIP for "HS_OPEN_CURSORS" returned "50"
                HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
                HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
                HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
                HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
                HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
                HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
                HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
                HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
                treat_SQLLEN_as_compiled = 1
                Exiting hgoinit, rc=0 at 2013/02/12-08:18:16
                Entered hgolgon at 2013/02/12-08:18:16
                reco:0, name:tytancc2, tflag:0
                Entered hgosuec at 2013/02/12-08:18:16
                Exiting hgosuec, rc=0 at 2013/02/12-08:18:16
                HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
                HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
                HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
                HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
                HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
                HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
                HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
                HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
                HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
                HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
                using tytancc2 as default value for "HS_FDS_DEFAULT_OWNER"
                HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
                Entered hgocont at 2013/02/12-08:18:16
                HS_FDS_CONNECT_INFO = "AAA1"
                RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
                Entered hgogenconstr at 2013/02/12-08:18:16
                dsn:AAA1, name:tytancc2
                optn:
                Entered hgocip at 2013/02/12-08:18:16
                dsn:AAA1
                Exiting hgocip, rc=0 at 2013/02/12-08:18:16
                Exiting hgogenconstr, rc=0 at 2013/02/12-08:18:16
                Entered hgolosf at 2013/02/12-08:18:20
                Exiting hgolosf, rc=0 at 2013/02/12-08:18:20
                DriverName:libmyodbc5w.so, DriverVer:05.02.0002
                DBMS Name:MySQL, DBMS Version:5.1.66-community-log
                Exiting hgocont, rc=0 at 2013/02/12-08:18:20
                SQLGetInfo returns Y for SQL_CATALOG_NAME
                SQLGetInfo returns 192 for SQL_MAX_CATALOG_NAME_LEN
                Exiting hgolgon, rc=0 at 2013/02/12-08:18:20
                Entered hgoulcp at 2013/02/12-08:18:20
                Entered hgowlst at 2013/02/12-08:18:20
                Exiting hgowlst, rc=0 at 2013/02/12-08:18:20
                SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
                TXN Capable:3, Isolation Option:0xf
                SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
                SQLGetInfo returns 192 for SQL_MAX_TABLE_NAME_LEN
                SQLGetInfo returns 192 for SQL_MAX_PROCEDURE_NAME_LEN
                SQLGetInfo returns ` (0x60) for SQL_IDENTIFIER_QUOTE_CHAR
                SQLGetInfo returns Y for SQL_COLUMN_ALIAS
                16 instance capabilities will be uploaded
                capno:1964, context:0x00000000, add-info: 0
                capno:1989, context:0x00000000, add-info: 0
                capno:1991, context:0x0001ffff, add-info: 0
                capno:1992, context:0x0001ffff, add-info: 1, translation:"`"
                capno:3042, context:0x00000000, add-info: 0, translation:"42"
                capno:3047, context:0x00000000, add-info: 0, translation:"57"
                capno:3049, context:0x00000000, add-info: 0, translation:"59"
                capno:3050, context:0x00000000, add-info: 0, translation:"60"
                capno:3066, context:0x00000000, add-info: 0
                capno:3067, context:0x00000000, add-info: 0
                capno:3068, context:0x00000000, add-info: 0
                capno:3069, context:0x00000000, add-info: 0
                capno:3500, context:0x00000001, add-info: 91, translation:"42"
                capno:3501, context:0x00000001, add-info: 93, translation:"57"
                capno:3502, context:0x00000001, add-info: 107, translation:"59"
                capno:3503, context:0x00000001, add-info: 110, translation:"60"
                Exiting hgoulcp, rc=0 at 2013/02/12-08:18:20
                Entered hgouldt at 2013/02/12-08:18:20
                NO instance DD translations were uploaded
                Exiting hgouldt, rc=0 at 2013/02/12-08:18:20
                Entered hgobegn at 2013/02/12-08:18:20
                tflag:0 , initial:1
                hoi:0x527562c8, ttid (len 27) is ...
                00: 54595441 4E2E6438 32323564 62642E31 [TYTAN.d8225dbd.1]
                10: 382E3339 2E353132 373333 [8.39.512733]
                tbid (len 10) is ...
                0: 12002700 DDD20700 0104 [..'.......]
                Exiting hgobegn, rc=0 at 2013/02/12-08:18:20
                Entered hgodtab at 2013/02/12-08:18:20
                count:1
                table: SUBSCRIBERS
                Allocate hoada[0] @ 0x1be51590
                Entered hgopcda at 2013/02/12-08:18:20
                Column:1(MSISDN): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:2(IMSI): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:3(ICC): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:4(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:5(REPLYATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:6(TIMELEFT): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:7(ELIMINATED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                Entered hgopcda at 2013/02/12-08:18:20
                Column:8(SUSPENDED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:20
                The hoada for table SUBSCRIBERS follows...
                hgodtab, line 876: Printing hoada @ 0x1be51590
                MAX:8, ACTUAL:8, BRC:1, WHT=6 (TABLE_DESCRIBE)
                hoadaMOD bit-values found (0x200:TREAT_AS_CHAR,0x20:NEGATIVE_HOADADTY)
                DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                1 CHAR N 8 8 0/ 0 0 0 200 MSISDN
                -5 BIGINT N 8 8 0/ 0 0 0 20 IMSI
                -5 BIGINT N 8 8 0/ 0 0 0 20 ICC
                1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
                1 CHAR Y 200 200 0/ 0 0 0 200 REPLYATTR
                -5 BIGINT Y 8 8 0/ 0 0 0 20 TIMELEFT
                -5 BIGINT Y 8 8 0/ 0 0 0 20 ELIMINATED
                -5 BIGINT Y 8 8 0/ 0 0 0 20 SUSPENDED
                Exiting hgodtab, rc=0 at 2013/02/12-08:18:21
                Entered hgodafr, cursor id 0 at 2013/02/12-08:18:21
                Free hoada @ 0x1be51590
                Exiting hgodafr, rc=0 at 2013/02/12-08:18:21
                Entered hgopars, cursor id 1 at 2013/02/12-08:18:21
                type:0
                SQL text from hgopars, id=1, len=43 ...
                00: 53454C45 43542041 312E6043 4845434B [SELECT A1.`CHECK]
                10: 41545452 60204652 4F4D2060 53554253 [ATTR` FROM `SUBS]
                20: 43524942 45525360 204131 [CRIBERS` A1]
                Exiting hgopars, rc=0 at 2013/02/12-08:18:21
                Entered hgoopen, cursor id 1 at 2013/02/12-08:18:21
                hgoopen, line 86: NO hoada to print
                Deferred open until first fetch.
                Exiting hgoopen, rc=0 at 2013/02/12-08:18:21
                Entered hgodscr, cursor id 1 at 2013/02/12-08:18:21
                Allocate hoada @ 0x1be51590
                Entered hgopcda at 2013/02/12-08:18:21
                Column:1(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:21
                hgodscr, line 880: Printing hoada @ 0x1be51590
                MAX:1, ACTUAL:1, BRC:1, WHT=5 (SELECT_LIST)
                hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
                DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
                Exiting hgodscr, rc=0 at 2013/02/12-08:18:21
                Entered hgopars, cursor id 2 at 2013/02/12-08:18:21
                type:0
                SQL text from hgopars, id=2, len=43 ...
                00: 53454C45 43542041 312E6043 4845434B [SELECT A1.`CHECK]
                10: 41545452 60204652 4F4D2060 53554253 [ATTR` FROM `SUBS]
                20: 43524942 45525360 204131 [CRIBERS` A1]
                Exiting hgopars, rc=0 at 2013/02/12-08:18:21
                Entered hgoopen, cursor id 2 at 2013/02/12-08:18:21
                hgoopen, line 86: NO hoada to print
                Deferred open until first fetch.
                Exiting hgoopen, rc=0 at 2013/02/12-08:18:21
                Entered hgodscr, cursor id 2 at 2013/02/12-08:18:21
                Allocate hoada @ 0x1be81338
                Entered hgopcda at 2013/02/12-08:18:21
                Column:1(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
                Exiting hgopcda, rc=0 at 2013/02/12-08:18:21
                hgodscr, line 880: Printing hoada @ 0x1be81338
                MAX:1, ACTUAL:1, BRC:1, WHT=5 (SELECT_LIST)
                hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
                DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
                Exiting hgodscr, rc=0 at 2013/02/12-08:18:21
                Entered hgoftch, cursor id 2 at 2013/02/12-08:18:21
                hgoftch, line 130: Printing hoada @ 0x1be81338
                MAX:1, ACTUAL:1, BRC:1, WHT=5 (SELECT_LIST)
                hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
                DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
                Performing delayed open.
                SQLBindCol: column 1, cdatatype: 1, bflsz: 201
                SQLFetch: row: 1, column 1, bflsz: 201, bflar: -1
                SQLFetch: row: 1, column 1, bflsz: 201, bflar: -1, (bfl: 200, mbl: 200)
                1 rows fetched
                Exiting hgoftch, rc=0 at 2013/02/12-08:18:21
                • 5. Re: Database Link Error to MySQL when using variables
                  Mkirtley-Oracle
                  Hi,
                  The trace shows that the fetchis successful -

                  SQLBindCol: column 1, cdatatype: 1, bflsz: 201
                  SQLFetch: row: 1, column 1, bflsz: 201, bflar: -1
                  SQLFetch: row: 1, column 1, bflsz: 201, bflar: -1, (bfl: 200, mbl: 200)
                  1 rows fetched
                  Exiting hgoftch, rc=0 at 2013/02/12-08:18:21

                  Could you get an ODBC trace so we can see how the column is being handled, fo rbuffer size etc ?
                  If you are using the Unixodbc driver manager then you need to setup tracing in the odbcinst.ini file and you need to add the following section -

                  # To enable unixODBC tracing, add this section to odbcinst.ini.
                  # Include the [ODBC] section heading.
                  [ODBC]
                  Trace = yes
                  TraceFile = trace_file_path

                  The odbcinst.ini file can be found by the command -

                  odbc_config --odbcinstini

                  Something like -
                  Default output:
                  /usr/local/etc/odbcinst.ini

                  will be shown.

                  Ths is detailed in the following note -

                  How to Enable unixODBC Tracing (Doc ID 750692.1)

                  For other driver managers and drivers then tracing just needs to be set in the odbc.ini file.

                  The only other issue is that if you specify a trace file name then it may be ignored and a file called sql.log created.

                  Regards,
                  Mike
                  • 6. Re: Database Link Error to MySQL when using variables
                    Kgronau-Oracle
                    If it is possible, please also provide the source table description as it is defined in the MySQl database (above you only posted how the table is represented through the gateway).

                    thanks,
                    Klaus
                    • 7. Re: Database Link Error to MySQL when using variables
                      ZGibson_BZ
                      Hi Guys,

                      Sorry for the delay, things have been a bit crazy at work. I've made one slight change in that I'm pointing to the live database but in utf8 instead of latin and table name "subscribers2" instead of "subscribers". I'm still having the same issue with readin Null value columns.

                      Thanks,
                      Zane

                      Table Desc:
                      +------------+------------+------+-----+---------+-------+
                      | Field      | Type       | Null | Key | Default | Extra |
                      +------------+------------+------+-----+---------+-------+
                      | MSISDN     | char(8)    | YES  | UNI | NULL    |       |
                      | IMSI       | bigint(20) | NO   | MUL | NULL    |       |
                      | ICC        | bigint(20) | NO   | MUL | NULL    |       |
                      | CHECKATTR  | char(200)  | YES  |     | NULL    |       |
                      | REPLYATTR  | char(200)  | YES  |     | NULL    |       |
                      | TIMELEFT   | int(11)    | YES  |     | NULL    |       |
                      | ELIMINATED | int(11)    | YES  |     | NULL    |       |
                      | SUSPENDED  | int(11)    | YES  |     | NULL    |       |
                      +------------+------------+------+-----+---------+-------+
                      • 8. Re: Database Link Error to MySQL when using variables
                        ZGibson_BZ
                        Tarcefile:
                        [ODBC][379][1360881002.943407][SQLSetConnectAttr.c][396]
                                  Entry:
                                       Connection = 0x123d8530
                                       Attribute = SQL_ATTR_AUTOCOMMIT
                                       Value = (nil)
                                       StrLen = -5
                        [ODBC][379][1360881002.943469][SQLSetConnectAttr.c][681]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.943799][SQLDriverConnect.c][726]
                                  Entry:
                                       Connection = 0x123d8530
                                       Window Hdl = (nil)
                                       Str In = [DSN=AAA1;UID=tytancc;PWD=**************][length = 39]
                                       Str Out = 0x123da618
                                       Str Out Max = 1024
                                       Str Out Ptr = 0x7fffe2e98bc0
                                       Completion = 0
                                  UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2LE'
                        
                        [ODBC][379][1360881002.960927][SQLDriverConnect.c][1582]
                                  Exit:[SQL_SUCCESS]
                                       Connection Out [[DSN=AAA1;UID=tytancc;PWD=**************][length = 39 (SQL_NTS)]]
                        [ODBC][379][1360881002.961044][SQLGetFunctions.c][151]
                                  Entry:
                                       Connection = 0x123d8530
                                       Id = 999
                                       Supported = 0x123c2db8
                        [ODBC][379][1360881002.961075][SQLGetFunctions.c][186]
                                  Exit:[SQL_SUCCESS]
                                       Supported = 0x123c2db8 -> -2
                        [ODBC][379][1360881002.961223][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_DRIVER_NAME (6)
                                       Info Value = 0x7fffe2e988c0
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98bc4
                        [ODBC][379][1360881002.961266][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.961296][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_DRIVER_VER (7)
                                       Info Value = 0x7fffe2e988c0
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98bc4
                        [ODBC][379][1360881002.961321][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.961357][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_DBMS_NAME (17)
                                       Info Value = 0x7fffe2e988c0
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98bc4
                        [ODBC][379][1360881002.961383][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.961409][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_DBMS_VER (18)
                                       Info Value = 0x7fffe2e988c0
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98bc4
                        [ODBC][379][1360881002.961434][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.961498][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_CATALOG_NAME (10003)
                                       Info Value = 0x7fffe2e98c20
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98eb0
                        [ODBC][379][1360881002.961527][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.961581][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_MAX_CATALOG_NAME_LEN (34)
                                       Info Value = 0x7fffe2e98eac
                                       Buffer Length = 2
                                       StrLen = (nil)
                        [ODBC][379][1360881002.961606][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.961649][SQLGetConnectAttr.c][292]
                                  Entry:
                                       Connection = 0x123d8530
                                       Attribute = SQL_ATTR_CURRENT_CATALOG
                                       Value = 0x123da958
                                       Buffer Length = 192
                                       StrLen = 0x123c3128
                        [ODBC][379][1360881002.963429][SQLGetConnectAttr.c][758]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974072][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_SCHEMA_USAGE (91)
                                       Info Value = 0x7fffe2e98f94
                                       Buffer Length = 4
                                       StrLen = 0x7fffe2e98fa8
                        [ODBC][379][1360881002.974134][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974191][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_TXN_CAPABLE (46)
                                       Info Value = 0x123c369c
                                       Buffer Length = 2
                                       StrLen = 0x7fffe2e98fb0
                        [ODBC][379][1360881002.974230][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974266][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_TXN_ISOLATION_OPTION (72)
                                       Info Value = 0x123c36a0
                                       Buffer Length = 4
                                       StrLen = 0x7fffe2e98fb0
                        [ODBC][379][1360881002.974302][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974355][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_MAX_SCHEMA_NAME_LEN (32)
                                       Info Value = 0x7fffe2e98fac
                                       Buffer Length = 2
                                       StrLen = 0x7fffe2e98fa8
                        [ODBC][379][1360881002.974393][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974446][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_MAX_TABLE_NAME_LEN (35)
                                       Info Value = 0x7fffe2e98fac
                                       Buffer Length = 2
                                       StrLen = 0x7fffe2e98fa8
                        [ODBC][379][1360881002.974512][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974566][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_MAX_PROCEDURE_NAME_LEN (33)
                                       Info Value = 0x7fffe2e98fac
                                       Buffer Length = 2
                                       StrLen = 0x7fffe2e98fa8
                        [ODBC][379][1360881002.974604][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974664][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_IDENTIFIER_QUOTE_CHAR (29)
                                       Info Value = 0x7fffe2e98ce0
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98fa8
                        [ODBC][379][1360881002.974710][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974787][SQLGetInfo.c][554]
                                  Entry:
                                       Connection = 0x123d8530
                                       Info Type = SQL_COLUMN_ALIAS (87)
                                       Info Value = 0x7fffe2e98ce0
                                       Buffer Length = 512
                                       StrLen = 0x7fffe2e98fa8
                        [ODBC][379][1360881002.974830][SQLGetInfo.c][617]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.974898][SQLAllocHandle.c][540]
                                  Entry:
                                       Handle Type = 3
                                       Input Handle = 0x123d8530
                        [ODBC][379][1360881002.975004][SQLAllocHandle.c][1081]
                                  Exit:[SQL_SUCCESS]
                                       Output Handle = 0x12401d00
                        [ODBC][379][1360881002.975050][SQLBindCol.c][236]
                                  Entry:
                                       Statement = 0x12401d00
                                       Column Number = 1
                                       Target Type = 1 SQL_CHAR
                                       Target Value = 0x7fffe2e98c50
                                       Buffer Length = 120
                                       StrLen Or Ind = 0x7fffe2e98f38
                        [ODBC][379][1360881002.975122][SQLBindCol.c][341]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975162][SQLBindCol.c][236]
                                  Entry:
                                       Statement = 0x12401d00
                                       Column Number = 3
                                       Target Type = -16 SQL_C_SLONG
                                       Target Value = 0x7fffe2e98f90
                                       Buffer Length = 0
                                       StrLen Or Ind = 0x7fffe2e98f28
                        [ODBC][379][1360881002.975200][SQLBindCol.c][341]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975238][SQLBindCol.c][236]
                                  Entry:
                                       Statement = 0x12401d00
                                       Column Number = 10
                                       Target Type = -15 SQL_C_SSHORT
                                       Target Value = 0x7fffe2e98fa4
                                       Buffer Length = 0
                                       StrLen Or Ind = 0x7fffe2e98f30
                        [ODBC][379][1360881002.975275][SQLBindCol.c][341]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975314][SQLGetTypeInfo.c][168]
                                  Entry:
                                       Statement = 0x12401d00
                                       Data Type = SQL_VARCHAR
                        [ODBC][379][1360881002.975451][SQLGetTypeInfo.c][318]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975494][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.975581][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975618][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.975653][SQLFetch.c][348]
                                  Exit:[SQL_NO_DATA]
                        [ODBC][379][1360881002.975690][SQLFreeStmt.c][144]
                                  Entry:
                                       Statement = 0x12401d00
                                       Option = 0
                        [ODBC][379][1360881002.975727][SQLFreeStmt.c][263]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975763][SQLGetTypeInfo.c][168]
                                  Entry:
                                       Statement = 0x12401d00
                                       Data Type = SQL_INTEGER
                        [ODBC][379][1360881002.975820][SQLGetTypeInfo.c][318]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975857][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.975908][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.975945][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.975987][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976022][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976064][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976100][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976140][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976175][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976217][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976251][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976291][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976326][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976367][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976401][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976462][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976498][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976539][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976574][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976615][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976649][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976690][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976725][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976766][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976801][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.976834][SQLFetch.c][348]
                                  Exit:[SQL_NO_DATA]
                        [ODBC][379][1360881002.976874][SQLFreeStmt.c][144]
                                  Entry:
                                       Statement = 0x12401d00
                                       Option = 0
                        [ODBC][379][1360881002.976909][SQLFreeStmt.c][263]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.976945][SQLGetTypeInfo.c][168]
                                  Entry:
                                       Statement = 0x12401d00
                                       Data Type = SQL_INTEGER
                        [ODBC][379][1360881002.977002][SQLGetTypeInfo.c][318]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977045][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977088][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977123][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977164][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977213][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977257][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977294][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977335][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977370][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977411][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977446][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977486][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977521][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977562][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977598][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977638][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977674][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977716][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977751][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977793][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977828][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977874][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.977912][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.977976][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978026][SQLFreeStmt.c][144]
                                  Entry:
                                       Statement = 0x12401d00
                                       Option = 0
                        [ODBC][379][1360881002.978052][SQLFreeStmt.c][263]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978075][SQLGetTypeInfo.c][168]
                                  Entry:
                                       Statement = 0x12401d00
                                       Data Type = SQL_SMALLINT
                        [ODBC][379][1360881002.978115][SQLGetTypeInfo.c][318]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978138][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978166][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978188][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978214][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978236][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978261][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978283][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978309][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978331][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978373][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978396][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978417][SQLFetch.c][348]
                                  Exit:[SQL_NO_DATA]
                        [ODBC][379][1360881002.978439][SQLFreeStmt.c][144]
                                  Entry:
                                       Statement = 0x12401d00
                                       Option = 0
                        [ODBC][379][1360881002.978461][SQLFreeStmt.c][263]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978483][SQLGetTypeInfo.c][168]
                                  Entry:
                                       Statement = 0x12401d00
                                       Data Type = SQL_SMALLINT
                        [ODBC][379][1360881002.978519][SQLGetTypeInfo.c][318]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978546][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978573][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978596][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978621][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978644][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978669][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978691][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978717][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978739][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978764][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978786][SQLFreeStmt.c][144]
                                  Entry:
                                       Statement = 0x12401d00
                                       Option = 0
                        [ODBC][379][1360881002.978808][SQLFreeStmt.c][263]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978831][SQLGetTypeInfo.c][168]
                                  Entry:
                                       Statement = 0x12401d00
                                       Data Type = SQL_VARBINARY
                        [ODBC][379][1360881002.978866][SQLGetTypeInfo.c][318]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978895][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978926][SQLFetch.c][348]
                                  Exit:[SQL_SUCCESS]
                        [ODBC][379][1360881002.978950][SQLFetch.c][162]
                                  Entry:
                                       Statement = 0x12401d00
                        [ODBC][379][1360881002.978972][SQLFetch.c][348]
                                  Exit:[SQL_NO_DATA]
                        [ODBC][379][1360881002.978994][SQLFreeStmt.c][144]
                        • 9. Re: Database Link Error to MySQL when using variables
                          ZGibson_BZ
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.979016][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979038][SQLGetTypeInfo.c][168]
                                    Entry:
                                         Statement = 0x12401d00
                                         Data Type = SQL_BIGINT
                          [ODBC][379][1360881002.979073][SQLGetTypeInfo.c][318]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979096][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979122][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979144][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979169][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979191][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979220][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979242][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979267][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979289][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979310][SQLFetch.c][348]
                                    Exit:[SQL_NO_DATA]
                          [ODBC][379][1360881002.979332][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.979354][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979376][SQLGetTypeInfo.c][168]
                                    Entry:
                                         Statement = 0x12401d00
                                         Data Type = SQL_BIGINT
                          [ODBC][379][1360881002.979411][SQLGetTypeInfo.c][318]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979437][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979463][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979486][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979511][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979533][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979559][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979581][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979606][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979644][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.979667][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979689][SQLGetTypeInfo.c][168]
                                    Entry:
                                         Statement = 0x12401d00
                                         Data Type = SQL_TINYINT
                          [ODBC][379][1360881002.979728][SQLGetTypeInfo.c][318]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979762][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979801][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979835][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979882][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979920][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.979962][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.979998][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980040][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980074][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980107][SQLFetch.c][348]
                                    Exit:[SQL_NO_DATA]
                          [ODBC][379][1360881002.980140][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.980176][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980214][SQLGetTypeInfo.c][168]
                                    Entry:
                                         Statement = 0x12401d00
                                         Data Type = SQL_TINYINT
                          [ODBC][379][1360881002.980270][SQLGetTypeInfo.c][318]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980313][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980356][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980392][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980435][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980471][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980512][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980547][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980588][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980624][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.980661][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980694][SQLGetTypeInfo.c][168]
                                    Entry:
                                         Statement = 0x12401d00
                                         Data Type = SQL_LONGVARCHAR
                          [ODBC][379][1360881002.980749][SQLGetTypeInfo.c][318]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980785][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.980827][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980862][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.980903][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.980938][SQLGetTypeInfo.c][168]
                                    Entry:
                                         Statement = 0x12401d00
                                         Data Type = SQL_LONGVARBINARY
                          [ODBC][379][1360881002.980993][SQLGetTypeInfo.c][318]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.981028][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881002.981070][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.981105][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881002.981140][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.981175][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 2
                          [ODBC][379][1360881002.981208][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.994533][SQLEndTran.c][421]
                                    Entry:                
                                         Connection = 0x123d8530                
                                         Completion Type = 0
                          [ODBC][379][1360881002.996504][SQLGetInfo.c][554]
                                    Entry:
                                         Connection = 0x123d8530
                                         Info Type = SQL_CURSOR_COMMIT_BEHAVIOR (23)
                                         Info Value = 0x123d99a0
                                         Buffer Length = 2
                                         StrLen = 0x7fffe2e98e5e
                          [ODBC][379][1360881002.996546][SQLGetInfo.c][617]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.996572][SQLGetInfo.c][554]
                                    Entry:
                                         Connection = 0x123d8530
                                         Info Type = SQL_CURSOR_ROLLBACK_BEHAVIOR (24)
                                         Info Value = 0x123d99a2
                                         Buffer Length = 2
                                         StrLen = 0x7fffe2e98e5e
                          [ODBC][379][1360881002.996613][SQLGetInfo.c][617]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.996636][SQLEndTran.c][574]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881002.996666][SQLSetConnectAttr.c][396]
                                    Entry:
                                         Connection = 0x123d8530
                                         Attribute = SQL_ATTR_TXN_ISOLATION
                                         Value = 0x2
                                         StrLen = -5
                          [ODBC][379][1360881002.999108][SQLSetConnectAttr.c][852]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.002982][SQLAllocHandle.c][540]
                                    Entry:
                                         Handle Type = 3
                                         Input Handle = 0x123d8530
                          [ODBC][379][1360881003.003054][SQLAllocHandle.c][1081]
                                    Exit:[SQL_SUCCESS]
                                         Output Handle = 0x12439eb0
                          [ODBC][379][1360881003.003087][SQLFreeHandle.c][381]
                                    Entry:
                                         Handle Type = 3
                                         Input Handle = 0x12401d00
                          [ODBC][379][1360881003.003139][SQLFreeHandle.c][491]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003164][SQLAllocHandle.c][540]
                                    Entry:
                                         Handle Type = 3
                                         Input Handle = 0x123d8530
                          [ODBC][379][1360881003.003196][SQLAllocHandle.c][1081]
                                    Exit:[SQL_SUCCESS]
                                         Output Handle = 0x12401d00
                          [ODBC][379][1360881003.003221][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 4
                                         Target Type = 1 SQL_CHAR
                                         Target Value = 0x7fffe2e98dc0
                                         Buffer Length = 124
                                         StrLen Or Ind = 0x7fffe2e98e90
                          [ODBC][379][1360881003.003249][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003273][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 5
                                         Target Type = -15 SQL_C_SSHORT
                                         Target Value = 0x7fffe2e98f58
                                         Buffer Length = 0
                                         StrLen Or Ind = (nil)
                          [ODBC][379][1360881003.003296][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003319][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 6
                                         Target Type = 1 SQL_CHAR
                                         Target Value = 0x7fffe2e98d28
                                         Buffer Length = 120
                                         StrLen Or Ind = 0x7fffe2e98eb8
                          [ODBC][379][1360881003.003342][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003365][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 7
                                         Target Type = -16 SQL_C_SLONG
                                         Target Value = 0x7fffe2e98f34
                                         Buffer Length = 0
                                         StrLen Or Ind = 0x7fffe2e98e98
                          [ODBC][379][1360881003.003387][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003410][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 9
                                         Target Type = -15 SQL_C_SSHORT
                                         Target Value = 0x7fffe2e98f5c
                                         Buffer Length = 0
                                         StrLen Or Ind = 0x7fffe2e98ea0
                          [ODBC][379][1360881003.003433][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003456][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 10
                                         Target Type = -15 SQL_C_SSHORT
                                         Target Value = 0x7fffe2e98f64
                                         Buffer Length = 0
                                         StrLen Or Ind = 0x7fffe2e98ec0
                          [ODBC][379][1360881003.003479][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003501][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 11
                                         Target Type = -15 SQL_C_SSHORT
                                         Target Value = 0x7fffe2e98f60
                                         Buffer Length = 0
                                         StrLen Or Ind = (nil)
                          [ODBC][379][1360881003.003524][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003547][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x12401d00
                                         Column Number = 16
                                         Target Type = -16 SQL_C_SLONG
                                         Target Value = 0x7fffe2e98f40
                                         Buffer Length = 0
                                         StrLen Or Ind = 0x7fffe2e98ea8
                          [ODBC][379][1360881003.003572][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.003623][SQLColumns.c][215]
                                    Entry:
                                         Statement = 0x12401d00
                                         Catalog Name = [radiator][length = 8]
                                         Schema Name = [NULL]
                                         Table Name = [SUBSCRIBERS2][length = 12]
                                         Column Name = [NULL]
                          [ODBC][379][1360881003.014993][SQLColumns.c][412]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015172][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015247][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015361][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015396][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015479][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015513][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015613][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015647][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015726][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015758][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015836][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015870][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.015961][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.015994][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.016072][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.016104][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.016183][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x12401d00
                          [ODBC][379][1360881003.016209][SQLFetch.c][348]
                                    Exit:[SQL_NO_DATA]
                          [ODBC][379][1360881003.016284][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 0
                          [ODBC][379][1360881003.016311][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.016438][SQLFreeStmt.c][144]
                                    Entry:
                                         Statement = 0x12401d00
                                         Option = 2
                          [ODBC][379][1360881003.016465][SQLFreeStmt.c][263]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.016489][SQLFreeHandle.c][381]
                                    Entry:
                                         Handle Type = 3
                                         Input Handle = 0x12439eb0
                          [ODBC][379][1360881003.016521][SQLFreeHandle.c][491]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.029258][SQLAllocHandle.c][540]
                                    Entry:
                                         Handle Type = 3
                                         Input Handle = 0x123d8530
                          [ODBC][379][1360881003.029318][SQLAllocHandle.c][1081]
                                    Exit:[SQL_SUCCESS]
                                         Output Handle = 0x12439eb0
                          [ODBC][379][1360881003.029350][SQLPrepare.c][196]
                                    Entry:
                                         Statement = 0x12439eb0
                                         SQL = [SELECT A1.`CHECKATTR` FROM `SUBSCRIBERS2` A1 WHERE A1.`MSISDN`='610-0850'][length = 73]
                          [ODBC][379][1360881003.029450][SQLPrepare.c][371]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.029482][SQLNumResultCols.c][156]
                                    Entry:
                                         Statement = 0x12439eb0
                                         Column Count = 0x123c4538
                          [ODBC][379][1360881003.033825][SQLNumResultCols.c][248]
                                    Exit:[SQL_SUCCESS]
                                         Count = 0x123c4538 -> 1
                          [ODBC][379][1360881003.034106][SQLDescribeCol.c][247]
                                    Entry:
                                         Statement = 0x12439eb0
                                         Column Number = 1
                                         Column Name = 0x7fffe2e98c80
                                         Buffer Length = 31
                                         Name Length = 0x7fffe2e98dc4
                                         Data Type = 0x7fffe2e98dc8
                                         Column Size = 0x7fffe2e98d60
                                         Decimal Digits = 0x7fffe2e98dcc
                                         Nullable = 0x7fffe2e98dd0
                          [ODBC][379][1360881003.034152][SQLDescribeCol.c][497]
                                    Exit:[SQL_SUCCESS]                
                                         Column Name = [CHECKATTR]                
                                         Data Type = 0x7fffe2e98dc8 -> 1                
                                         Column Size = 0x7fffe2e98d60 -> 200                
                                         Decimal Digits = 0x7fffe2e98dcc -> 0                
                                         Nullable = 0x7fffe2e98dd0 -> 1
                          [ODBC][379][1360881003.034182][SQLColAttribute.c][293]
                                    Entry:
                                         Statement = 0x12439eb0
                                         Column Number = 1
                                         Field Identifier = SQL_DESC_OCTET_LENGTH
                                         Character Attr = (nil)
                                         Buffer Length = 0
                                         String Length = (nil)
                                         Numeric Attribute = 0x7fffe2e98d68
                          [ODBC][379][1360881003.034245][SQLColAttribute.c][664]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.034336][SQLSetStmtAttr.c][265]
                                    Entry:
                                         Statement = 0x12439eb0
                                         Attribute = SQL_ATTR_ROW_ARRAY_SIZE
                                         Value = 0x1
                                         StrLen = 0
                          [ODBC][379][1360881003.034370][SQLSetStmtAttr.c][925]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.038845][SQLAllocHandle.c][540]
                                    Entry:
                                         Handle Type = 3
                                         Input Handle = 0x123d8530
                          [ODBC][379][1360881003.038910][SQLAllocHandle.c][1081]
                                    Exit:[SQL_SUCCESS]
                                         Output Handle = 0x1244ae50
                          [ODBC][379][1360881003.038941][SQLPrepare.c][196]
                                    Entry:
                                         Statement = 0x1244ae50
                                         SQL = [SELECT A1.`CHECKATTR` FROM `SUBSCRIBERS2` A1 WHERE A1.`MSISDN`='610-0850'][length = 73]
                          [ODBC][379][1360881003.038986][SQLPrepare.c][371]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.039011][SQLNumResultCols.c][156]
                                    Entry:
                                         Statement = 0x1244ae50
                                         Column Count = 0x123c45c0
                          [ODBC][379][1360881003.041037][SQLNumResultCols.c][248]
                                    Exit:[SQL_SUCCESS]
                                         Count = 0x123c45c0 -> 1
                          [ODBC][379][1360881003.041271][SQLDescribeCol.c][247]
                                    Entry:
                                         Statement = 0x1244ae50
                                         Column Number = 1
                                         Column Name = 0x7fffe2e98c80
                                         Buffer Length = 31
                                         Name Length = 0x7fffe2e98dc4
                                         Data Type = 0x7fffe2e98dc8
                                         Column Size = 0x7fffe2e98d60
                                         Decimal Digits = 0x7fffe2e98dcc
                                         Nullable = 0x7fffe2e98dd0
                          [ODBC][379][1360881003.041311][SQLDescribeCol.c][497]
                                    Exit:[SQL_SUCCESS]                
                                         Column Name = [CHECKATTR]                
                                         Data Type = 0x7fffe2e98dc8 -> 1                
                                         Column Size = 0x7fffe2e98d60 -> 200                
                                         Decimal Digits = 0x7fffe2e98dcc -> 0                
                                         Nullable = 0x7fffe2e98dd0 -> 1
                          [ODBC][379][1360881003.041337][SQLColAttribute.c][293]
                                    Entry:
                                         Statement = 0x1244ae50
                                         Column Number = 1
                                         Field Identifier = SQL_DESC_OCTET_LENGTH
                                         Character Attr = (nil)
                                         Buffer Length = 0
                                         String Length = (nil)
                                         Numeric Attribute = 0x7fffe2e98d68
                          [ODBC][379][1360881003.041362][SQLColAttribute.c][664]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.041444][SQLSetStmtAttr.c][265]
                                    Entry:
                                         Statement = 0x1244ae50
                                         Attribute = SQL_ATTR_ROW_ARRAY_SIZE
                                         Value = 0x1
                                         StrLen = 0
                          [ODBC][379][1360881003.041472][SQLSetStmtAttr.c][925]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.043645][SQLExecute.c][187]
                                    Entry:
                                         Statement = 0x1244ae50
                          [ODBC][379][1360881003.048482][SQLExecute.c][348]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.048531][SQLBindCol.c][236]
                                    Entry:
                                         Statement = 0x1244ae50
                                         Column Number = 1
                                         Target Type = 1 SQL_CHAR
                                         Target Value = 0x12438f50
                                         Buffer Length = 201
                                         StrLen Or Ind = 0x12439060
                          [ODBC][379][1360881003.048559][SQLBindCol.c][341]
                                    Exit:[SQL_SUCCESS]
                          [ODBC][379][1360881003.048597][SQLFetch.c][162]
                                    Entry:
                                         Statement = 0x1244ae50
                          [ODBC][379][1360881003.048640][SQLFetch.c][348]
                                    Exit:[SQL_SUCCESS]
                          • 10. Re: Database Link Error to MySQL when using variables
                            Kgronau-Oracle
                            Did a quick test using this MySQL table:
                            create table gateway.SUBSCRIBERS (MSISDN char(8),IMSI bigint(20) not null ,ICC bigint(20) not null, CHECKATTR char(200), REPLYATTR char(200), TIMELEFT int(11),ELIMINATED int(11), SUSPENDED int(11) );
                            insert into gateway.SUBSCRIBERS values ('610-0850', 8950167090300132451, 702670161017765, NULL,NULL,NULL,NULL,NULL);
                            insert into gateway.SUBSCRIBERS values ('610-0850', 8950167090300132451, 702670161017765, 'Hello','Hello',99,99,99);


                            When I now use the gateway I can select and use the delete in the PL/SQl code:

                            SQL> select "MSISDN","ICC","IMSI","CHECKATTR","REPLYATTR","TIMELEFT","SUSPENDED","ELIMINATED" from "SUBSCRIBERS"@MYSQL_DG4ODBC_EMGTW_1123_DB;

                            MSISDN ICC IMSI CHECKATTR REPLYATTR TIMELEFT SUSPENDED ELIMINATED
                            ---------------- ---------- ----------
                            610-0850 7.0267E+14 8.9502E+18
                            610-0850 7.0267E+14 8.9502E+18 Hello Hello 99 99 99


                            SQL> Declare
                            2
                            3 MSISDN2 char(8);
                            4 IMSI2 number(28,0);
                            5 ICC2 number(28,0);
                            6 cnt number(28,0);
                            7
                            8 Begin
                            9 MSISDN2 :='610-0850';
                            10 IMSI2:=8950167090300132451;
                            11 ICC2:=702670161017765;
                            12
                            13 delete from "SUBSCRIBERS"@MYSQL_DG4ODBC_EMGTW_1123_DB where "MSISDN" = MSISDN2;
                            14 --"ICC" = ICC2 or "IMSI" = IMSI2;
                            15
                            16 End;
                            17 /

                            PL/SQL procedure successfully completed.

                            SQL> select count(*) from "SUBSCRIBERS"@MYSQL_DG4ODBC_EMGTW_1123_DB;

                            COUNT(*)
                            ----------
                            0

                            Edited by: kgronau on Feb 15, 2013 7:29 AM


                            When looking again at the gateway config I see HS_NLS_NCHAR= UCS2 is commented out. Please add this parameter again as you are using UnixODBC Driver manager which is compiled with
                                      UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2LE'

                            So please remove the hash sign in front of the gateway parameter.

                            Edited by: kgronau on Feb 15, 2013 7:36 AM


                            As you're now working in a Unicode environment I would also make sure that you use these parameters:
                            HS_KEEP_REMOTE_COLUMN_SIZE=ALL
                            HS_NLS_LENGTH_SEMANTICS=CHAR
                            HS_LANGUAGE=american_america.al32utf8

                            And please make sure the odbc.ini contains CHARSET=UTF8 instead of LATIN1
                            • 11. Re: Database Link Error to MySQL when using variables
                              ZGibson_BZ
                              Thanks for all the assistance guys. The initial question I had was answered. I still have the problem where I can only write in 64 bit and read in 32 bit mode (instead of full 64bit mode). The trace file for a read in 64 bit runs out garbage when it reaches a null value whereas in 32 bit it seems to interpret it correctly. When I resume work on this I'll open a new thread. Thanks once again.