10 Replies Latest reply on Mar 8, 2012 6:49 PM by Wile E. Coyote

    DG4ODBC configured and working but receiving ORA-28528 for some columns

    Wile E. Coyote
      DG4ODBC is configured and working for XE 11gR2 but under some circumstance receiving SQL Error: ORA-28528: Heterogeneous Services datatype conversion error.

      Configuration: DG4ODBC configured for Oracle 11gR2 using ODBC datasource based on IBM UniVerse ODBC Driver 4.00.04.7346 UVODBC.DLL (8/25/2009) all on same 32-bit Windows host for purpose of retrieving data from remote AIX based IBM/Rockit UniVerse version 10.1 database.

      Following 3 commands with corresponding results illustrate problem:

      select NO_PROD from bill_mat@dblink where NO_PROD not in ('15','20', '24', '6','10');

      no rows selected


      select NO_PROD, count (*) from bill_mat@dblink where NO_PROD in ('15','20', '24', '6','10') group by NO_PROD;

      NO_PROD COUNT(*)
      ---------- --------
      6 1
      20 1
      24 1
      10 9
      15 1

      select NO_PROD from bill_mat@dblink ;

      Error starting at line 19 in command:
      select NO_PROD from bill_mat@dblink
      Error report:
      SQL Error: ORA-28528: Heterogeneous Services datatype conversion error
      ORA-02063: preceding line from DBLINK
      28528. 00000 - "Heterogeneous Services datatype conversion error"
      *Cause:    Either an Oracle datatype could not be converted to a non-Oracle
      datatype, or a non-Oracle datatype could not be converted
      to an Oracle datatype. The following are possible reasons for
      for the conversion failure:
      -- overflow problems (in the case of numbers)
      -- length limitations (in the case of character strings)
      -- invalid values passed into the conversion routines
      *Action:   Contact customer support of the agent vendor. If the problem is
      due to size discrepancies between Oracle and the non-Oracle system,
      it may not be possible to convert the value.


      UniVerse LIST query shows many "blank" values for two fields LST.WO & NO.PROD that are problematic when attempting to query via DG4ODBC in the case of subject table "BILL_MAT":

      LIST BILL.MAT LST.WO NO.PROD LOCK 04:08:44pm 22 Nov 2011 PAGE 11
      BILL.MAT.. LST.WO.. NO.PROD LOCK

      239912 10
      220419
      247992
      252739
      249709
      239913 15
      184767
      164264
      184666
      164265
      247994
      239914
      251731
      249711
      173760
      239915 20
      242137
      247490
      247894
      254156
      Press any key to continue...



      Interestingly, output from this JDBC test app is different including references to "null" versus "blank" values referred to with LIST output above:

      import java.sql.*;
      import java.io.*;

      public class billmat {

      public static void main(String[] argv)
      {
      try {
      BufferedReader in = new BufferedReader(new InputStreamReader(System.in));



           //---------------------------
           // Connect to the U2 server
           //---------------------------

      String account = "universe_account";
      String userid = "username";
      String passwd = "password";
      String host = "AIX_Host";
      String url = "jdbc:ibm-u2://"+host+"/"+account+"?tracelevel=5;tracefile=qiang.trace";

      //Load driver and connect to server
      Class.forName("com.ibm.u2.jdbc.UniJDBCDriver");
      Connection con = DriverManager.getConnection(url, userid, passwd);

      System.out.println("\n\t*--- Connection successful ---*\n");


      System.out.println("1. Select from file BILL.MAT ------------------------");
      testQuery( con ) ;


      con.close();
      } catch ( SQLException e ) {
      System.out.println("Ex-Message :" + e.getMessage());
      System.out.println("Ex-Code :" + e.getErrorCode()) ;
      System.out.println("Ex-SQLState:" + e.getSQLState());
      System.out.println("Ex-Next :" + e.getNextException());
      e.printStackTrace() ;
      System.gc();
      } catch ( Exception e) {
      System.out.println("Exception caught:"+e) ;
      e.printStackTrace() ;
      }
      }


      /**
      * Select something from CUST.MAST file.
      * @param con The JDBC connection object.
      */
      public static void testQuery(Connection con)
      throws SQLException
      {
      Statement stmt = con.createStatement();
           String sql = "select DISTINCT LST.WO, NO.PROD, LOCK from BILL.MAT where LST.WO is not null or NO.PROD is not null";
      // Execute the SELECT statement
      ResultSet rs = stmt.executeQuery(sql);

      // Get result of first five records
      // System.out.println("\tlist selected columns for the first five records:");
      int i = 1;
      while (rs.next() && i < 100)
      {

                
                System.out.println("\tLST_WO : \t" + rs.getString(1));
                System.out.println("\tNO_PROD : \t" + rs.getString(2));
                System.out.println("\tLOCK : \t" + rs.getString(3));

           i++;
      }

      rs.close();
      stmt.close() ;
      System.out.println("\n\t*--- QUERY test is done successful ---*\n");
      System.out.println("\n\tDisplay Count: \t" + i);
      }

      }



      [root@VM-Linux01 Linux]# java billmat

      --- Connection successful ---

      1. Select from file BILL.MAT ------------------------
      LST_WO : null
      NO_PROD : null
      LOCK :
      LST_WO : null
      NO_PROD : 10
      LOCK :
      LST_WO : null
      NO_PROD : 15
      LOCK :
      LST_WO : null
      NO_PROD : 20
      LOCK :
      LST_WO : null
      NO_PROD : 6
      LOCK :
      LST_WO : null
      NO_PROD : 24
      LOCK :

      --- QUERY test is done successful ---


      Display Count: 7


      The reason column LOCK is included above is because it is queryable via DG4ODBC and shows up as (null) within query result submitted via and provided by SQLDeveloper.

      Considering results above it seems ORA-28528 IS NOT associated with overflow problems or length limitations. Rather, some sort of characterset mapping issue seems more plausible here. For instance, it seems NULL value returned in the case of columns LST_WO and NO_PROD from remote UniVerse database is not mapping correctly to how a NULL is represented within 11gR2 database. Is there some HS_% value within DG4ODBC init file that can be set to resolve this problem? I'm not well-versed in range of settings that exist but did try different values for HS_LANGUAGE which did not help.

      There is no problem using Excel MS Query to retrieve this data using same system DSN and associated ODBC driver on which DG4OBDC setup is based from same Windows machine where DG4ODBC is configured.

      These are current DG4ODBC settings for this instance (initDBLINK.ora):


      HS_FDS_CONNECT_INFO = DBLINK.ODBC
      HS_FDS_TRACE_LEVEL = ON
      HS_FDS_TRACE_FILE_NAME = c:/DG_LOG
      HS_FDS_TRACE_LEVEL = 4
      HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
      # Other HS_LANGUAGE settings attempted to resolve problem are commented below:
      # HS_LANGUAGE = american_america.utf8
      # HS_LANGUAGE = american_america.al32utf8


      Any guidance would be greatly appreciated!

      Edited by: WileyCoyote on Mar 8, 2012 1:33 PM

      Edited by: WileyCoyote on Mar 8, 2012 1:39 PM
        • 1. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
          Kgronau-Oracle
          A gateway trace level 255 (HS_FDS_TRACE_LEVEL0=255) would be interesting - also the source table definition (the way the table is defined in the IBM/Rockit UniVerse version 10.1 database).
          • 2. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
            Wile E. Coyote
            Hello kgronau:

            Thankyou for your reply! I've read through many of the threads on this forum and it's clear from this that you are very knowledgable in this area so thanks in advance for any insight you may be able to provide!

            Current HS configuration settings for SID DBLINK contained in file C:\oraclexe\app\oracle\product\11.2.0\server\hs\admin\initDBLINK.ora:_

            HS_FDS_CONNECT_INFO = DBLINK.ODBC
            HS_FDS_TRACE_LEVEL = ON
            HS_FDS_TRACE_LEVEL = 255
            HS_TRANSACTION_MODEL = READ_ONLY
            HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1


            Show execution of operation via sqlplus that produces ORA-28528 error using above configuration settings:_

            C:\Documents and Settings\Admin>sqlplus system/PW

            SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 28 09:12:00 2011

            Copyright (c) 1982, 2010, Oracle. All rights reserved.


            Connected to:
            Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

            SQL>
            SQL> select NO_PROD from bill_mat@dblink where rownum < 10;
            select NO_PROD from bill_mat@dblink where rownum < 10
            *
            ERROR at line 1:
            ORA-28528: Heterogeneous Services datatype conversion error
            ORA-02063: preceding line from DBLINK


            SQL> exit
            Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Produ
            ction


            Content of HS trace file resulting from above session_


            Content of file C:\oraclexe\app\oracle\product\11.2.0\server\hs\trace\DBLINK_agt_752.trc:

            Oracle Corporation --- MONDAY NOV 28 2011 09:12:05.429


            Heterogeneous Agent Release
            11.2.0.2.0




            Oracle Corporation --- MONDAY NOV 28 2011 09:12:05.429

            Version 11.2.0.2.0

            Entered hgogprd
            HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"
            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 "UCS2"
            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"
            setting HS_FDS_FETCH_ROWS to default of "100"
            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_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"
            Default value of 32 assumed 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 "DBLINK"
            Product-Info:
            Port Rls/Upd:2/0 PrdStat:0
            Agent:Oracle Database Gateway for ODBC
            Facility:hsa
            Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:DBLINK
            Exiting hgogprd, rc=0
            hostmstr: 2054266880:      HOA After hoagprd
            hostmstr: 2054266880:      HOA Before hoainit
            Entered hgoinit
            HOCXU_COMP_CSET=1
            HOCXU_DRV_CSET=31
            HOCXU_DRV_NCHAR=1000
            HOCXU_DB_CSET=873
            HS_LANGUAGE is AMERICAN_AMERICA.WE8ISO8859P1
            rc=1000 attempting to get LANG environment variable.
            HOCXU_SEM_VER=112000
            Entered hgolofn at 2011/11/28-09:12:05
            Exiting hgolofn, rc=0 at 2011/11/28-09:12:05
            HOSGIP for "HS_OPEN_CURSORS" returned "50"
            HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
            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"
            Invalid value of 32 given for HS_FDS_SQLLEN_INTERPRETATION
            treat_SQLLEN_as_compiled = 1
            Exiting hgoinit, rc=0 at 2011/11/28-09:12:05
            hostmstr: 2054266880:      HOA After hoainit
            hostmstr: 2054266880:      HOA Before hoalgon
            Entered hgolgon at 2011/11/28-09:12:05
            reco:0, name:odbc, tflag:0
            Entered hgosuec at 2011/11/28-09:12:05
            Exiting hgosuec, rc=0 at 2011/11/28-09:12:05
            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_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 odbc as default value for "HS_FDS_DEFAULT_OWNER"
            HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
            Entered hgocont at 2011/11/28-09:12:05
            HS_FDS_CONNECT_INFO = "DBLINK.ODBC"
            RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
            Entered hgogenconstr at 2011/11/28-09:12:05
            dsn:DBLINK.ODBC, name:odbc
            optn:
            Entered hgocip at 2011/11/28-09:12:05
            dsn:DBLINK.ODBC
            Exiting hgocip, rc=0 at 2011/11/28-09:12:05
            ##>Connect Parameters (len=35)<##
            ## DSN=DBLINK.ODBC;
            #! UID=odbc;
            #! PWD=*
            Exiting hgogenconstr, rc=0 at 2011/11/28-09:12:05
            Entered hgolosf at 2011/11/28-09:12:06
            ODBC Function-Available-Array 0xFFFE 0x00FF 0xFF00 0xFF7F 0x03DF 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
            0x0000 0x0000 0xEE00 0x3B5D
            Exiting hgolosf, rc=0 at 2011/11/28-09:12:06
            DriverName:UVODBC.DLL, DriverVer:3.7 Universe RDBMS 32-bit ODBC Driver
            DBMS Name:UniVerse, DBMS Version:10.1.0
            Exiting hgocont, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2700830]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgolgon, line 804: calling SQLGetInfo got sqlstate S1C00
            SQLGetInfo returns N for SQL_CATALOG_NAME
            Exiting hgolgon, rc=0 at 2011/11/28-09:12:06 with error ptr FILE:hgolgon.c LINE:804 ID:GetInfo: Support catalogs
            hostmstr: 2050433024:      HOA After hoalgon
            RPC Calling nscontrol(0), rc=0
            hostmstr: 2050433024: RPC Before Upload Caps
            hostmstr: 2050433024:      HOA Before hoaulcp
            Entered hgoulcp at 2011/11/28-09:12:06
            Entered hgowlst at 2011/11/28-09:12:06
            Exiting hgowlst, rc=0 at 2011/11/28-09:12:06
            SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
            TXN Capable:1, Isolation Option:0xf
            SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
            SQLGetInfo returns 72 for SQL_MAX_TABLE_NAME_LEN
            SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN
            SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
            SQLGetInfo returns Y for SQL_COLUMN_ALIAS
            7 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: 0
            capno:3007, context:0x00000000, add-info: -3, translation:"36"
            capno:3027, context:0x00000000, add-info: -1, translation:"0"
            capno:3036, context:0x00000000, add-info: -4, translation:"7"
            Exiting hgoulcp, rc=0 at 2011/11/28-09:12:06
            hostmstr: 2050433024:      HOA After hoaulcp
            hostmstr: 2050433024: RPC After Upload Caps
            hostmstr: 2050433024: RPC Before Upload DDTR
            hostmstr: 2050433024:      HOA Before hoauldt
            Entered hgouldt at 2011/11/28-09:12:06
            NO instance DD translations were uploaded
            Exiting hgouldt, rc=0 at 2011/11/28-09:12:06
            hostmstr: 2050433024:      HOA After hoauldt
            hostmstr: 2050433024: RPC After Upload DDTR
            hostmstr: 2050433024: RPC Before Begin Trans
            hostmstr: 2050433024:      HOA Before hoabegn
            Entered hgobegn at 2011/11/28-09:12:06
            tflag:1 , initial:1
            hoi:0x12f094, ttid (len 20) is ...
            00: 58452E38 31633633 6564392E 312E3231 [XE.81c63ed9.1.21]
            10: 2E333432 [.342]
            tbid (len 17) is ...
            00: 58455B31 2E32312E 3334325D 5B312E34 [XE[1.21.342][1.4]
            10: 5D []]
            Exiting hgobegn, rc=0 at 2011/11/28-09:12:06
            hostmstr: 2050433024:      HOA After hoabegn
            hostmstr: 2050433024: RPC After Begin Trans
            hostmstr: 2050433024: RPC Before Describe Table
            hostmstr: 2050433024:      HOA Before hoadtab
            Entered hgodtab at 2011/11/28-09:12:06
            count:1
            table: BILL_MAT
            Allocate hoada[0] @ 02F5D3D4
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1002; message follows...
            [Rocket U2][UVODBC][2702291]Invalid column number. {S1002}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodtab, line 588: calling SQLFetch got sqlstate S1002
            Entered hgodafr, cursor id 0 at 2011/11/28-09:12:06
            Free hoada @ 02F5D3D4
            Exiting hgodafr, rc=0 at 2011/11/28-09:12:06
            The hoada for table BILL_MAT follows...
            hgodtab, line 1092: NO hoada to print
            Exiting hgodtab, rc=28500 at 2011/11/28-09:12:06 with error ptr FILE:hgodtab.c LINE:588 ID:Fetching result set for tble descr
            hostmstr: 2050433024:      HOA After hoadtab
            hostmstr: 2050433024: RPC After Describe Table
            hostmstr: 2050433024: RPC Before SQL Bundling
            hostmstr: 2050433024:      HOA Before hoxpars
            Entered hgopars, cursor id 1 at 2011/11/28-09:12:06
            type:0
            SQL text from hgopars, id=1, len=24 ...
            00: 53454C45 4354202A 2046524F 4D202242 [SELECT * FROM "B]
            10: 494C4C5F 4D415422 [ILL_MAT"]
            Exiting hgopars, rc=0 at 2011/11/28-09:12:06
            hostmstr: 2050433024:      HOA After hoxpars
            hostmstr: 2050433024: RPC After SQL Bundling
            hostmstr: 2050433024: RPC Before SQL Bundling
            hostmstr: 2050433024:      HOA Before hoxopen
            Entered hgoopen, cursor id 1 at 2011/11/28-09:12:06
            hgoopen, line 87: NO hoada to print
            Deferred open until first fetch.
            Exiting hgoopen, rc=0 at 2011/11/28-09:12:06
            hostmstr: 2050433024:      HOA After hoxopen
            hostmstr: 2050433024:      HOA Before hoxdscr
            Entered hgodscr, cursor id 1 at 2011/11/28-09:12:06
            Allocate hoada @ 02F5D388
            Entered hgodscr_process_sellist_description at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:06
            Column:1(Z_ID): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:06
            Column:2(A_PROD_NO): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:3(BATCH_QTY): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:4(COST_UPD): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:5(CREATE_DT): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:6(LABOR): dtype:2 (NUMERIC), prc/scl:8/4, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:06
            Column:7(LOCK): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:8(LST_CST): dtype:2 (NUMERIC), prc/scl:7/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:9(LST_PROD): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:10(LST_WO): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:11(NO_PROD): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:06
            Column:12(P_C): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopcda at 2011/11/28-09:12:06
            Column:13(PRICE): dtype:2 (NUMERIC), prc/scl:4/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:06
            Column:14(PROD_DESC): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:06
            Column:15(PROD_DESC_QTY): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:06
            Entered hgopoer at 2011/11/28-09:12:06
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:07
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:07
            Column:16(PROD_NAME): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopoer at 2011/11/28-09:12:07
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:07
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:07
            Column:17(P_NAME): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopoer at 2011/11/28-09:12:07
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:07
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:07
            Column:18(QTY): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopoer at 2011/11/28-09:12:07
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:07
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:07
            Column:19(STOCK_UM): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:20(TOT_COST): dtype:2 (NUMERIC), prc/scl:8/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:21(TOT_COST4): dtype:2 (NUMERIC), prc/scl:8/4, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:22(TOT_LABOR_COST): dtype:2 (NUMERIC), prc/scl:8/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:23(TOT_LABOR_HRS): dtype:2 (NUMERIC), prc/scl:8/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:24(TOT_MAT_COST): dtype:2 (NUMERIC), prc/scl:8/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:25(TOT_OVHD_COST): dtype:2 (NUMERIC), prc/scl:8/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopoer at 2011/11/28-09:12:07
            hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
            [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
            Exiting hgopoer, rc=0 at 2011/11/28-09:12:07
            hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00
            Entered hgopcda at 2011/11/28-09:12:07
            Column:26(UM): dtype:12 (VARCHAR), prc/scl:254/0, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            Entered hgopcda at 2011/11/28-09:12:07
            Column:27(YIELD_): dtype:2 (NUMERIC), prc/scl:3/2, nullbl:1, octet:254, sign:1, radix:0
            Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
            hgodscr, line 457: Printing hoada @ 02F5D388
            MAX:27, ACTUAL:27, BRC:100, WHT=5 (SELECT_LIST)
            hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
            DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
            12 VARCHAR Y 254 254 0/ 0 0 0 200 Z_ID
            12 VARCHAR Y 254 254 0/ 0 0 0 200 A_PROD_NO
            4 INTEGER Y 4 4 0/ 0 0 0 0 BATCH_QTY
            91 DATE Y 16 16 0/ 0 0 0 0 COST_UPD
            91 DATE Y 16 16 0/ 0 0 0 0 CREATE_DT
            3 DECIMAL Y 11 11 8/ 4 0 0 0 LABOR
            12 VARCHAR Y 254 254 0/ 0 0 0 200 LOCK
            3 DECIMAL Y 10 10 7/ 2 0 0 0 LST_CST
            91 DATE Y 16 16 0/ 0 0 0 0 LST_PROD
            4 INTEGER Y 4 4 0/ 0 0 0 0 LST_WO
            4 INTEGER Y 4 4 0/ 0 0 0 0 NO_PROD
            12 VARCHAR Y 254 254 0/ 0 0 0 200 P_C
            3 DECIMAL Y 7 7 4/ 2 0 0 0 PRICE
            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_DESC
            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_DESC_QTY
            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_NAME
            12 VARCHAR Y 254 254 0/ 0 0 0 200 P_NAME
            12 VARCHAR Y 254 254 0/ 0 0 0 200 QTY
            12 VARCHAR Y 254 254 0/ 0 0 0 200 STOCK_UM
            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_COST
            3 DECIMAL Y 11 11 8/ 4 0 0 0 TOT_COST4
            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_LABOR_COST
            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_LABOR_HRS
            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_MAT_COST
            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_OVHD_COST
            12 VARCHAR Y 254 254 0/ 0 0 0 200 UM
            3 DECIMAL Y 6 6 3/ 2 0 0 0 YIELD_
            Exiting hgodscr, rc=0 at 2011/11/28-09:12:07

            <<<remainder of trace file included next post>>>

            Edited by: WileyCoyote on Mar 8, 2012 1:41 PM
            • 3. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
              Wile E. Coyote
              <<< remainder of trace file >>>

              hostmstr: 2050433024:      HOA After hoxdscr
              hostmstr: 2050433024: RPC After SQL Bundling
              hostmstr: 2050433024: RPC Before SQL Bundling
              hostmstr: 2050433024:      HOA Before hoxclse
              Entered hgoclse, cursor id 1 at 2011/11/28-09:12:07
              Exiting hgoclse, rc=0 at 2011/11/28-09:12:07
              hostmstr: 2050433024:      HOA After hoxclse
              hostmstr: 2050433024:      HOA Before hoadafr
              Entered hgodafr, cursor id 1 at 2011/11/28-09:12:07
              Free hoada @ 02F5D388
              Exiting hgodafr, rc=0 at 2011/11/28-09:12:07
              hostmstr: 2050433024:      HOA After hoadafr
              hostmstr: 2050433024:      HOA Before hoxpars
              Entered hgopars, cursor id 1 at 2011/11/28-09:12:07
              type:0
              SQL text from hgopars, id=1, len=32 ...
              00: 53454C45 43542022 4E4F5F50 524F4422 [SELECT "NO_PROD"]
              10: 2046524F 4D202242 494C4C5F 4D415422 [ FROM "BILL_MAT"]
              Exiting hgopars, rc=0 at 2011/11/28-09:12:07
              hostmstr: 2050433024:      HOA After hoxpars
              hostmstr: 2050433024:      HOA Before hoxopen
              Entered hgoopen, cursor id 1 at 2011/11/28-09:12:07
              hgoopen, line 87: NO hoada to print
              Deferred open until first fetch.
              Exiting hgoopen, rc=0 at 2011/11/28-09:12:07
              hostmstr: 2050433024:      HOA After hoxopen
              hostmstr: 2050433024:      HOA Before hoxdscr
              Entered hgodscr, cursor id 1 at 2011/11/28-09:12:07
              Allocate hoada @ 02F5D3D4
              Entered hgodscr_process_sellist_description at 2011/11/28-09:12:07
              Entered hgopcda at 2011/11/28-09:12:07
              Column:1(NO_PROD): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2011/11/28-09:12:07
              hgodscr, line 457: Printing hoada @ 02F5D3D4
              MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
              DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
              4 INTEGER Y 4 4 0/ 0 0 0 0 NO_PROD
              Exiting hgodscr, rc=0 at 2011/11/28-09:12:07
              hostmstr: 2050433024:      HOA After hoxdscr
              hostmstr: 2050433024: RPC After SQL Bundling
              hostmstr: 2050433024: RPC Before Fetch Row
              hostmstr: 2050433024:      HOA Before hoaftch
              Entered hgoftch, cursor id 1 at 2011/11/28-09:12:07
              hgoftch, line 130: Printing hoada @ 02F5D3D4
              MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
              DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
              4 INTEGER Y 4 4 0/ 0 0 0 0 NO_PROD
              Performing delayed open.
              SQLBindCol: column 1, cdatatype: -16, bflsz: 4
              SQLFetch: row: 1, column 1, bflsz: 4, bflar: -1
              SQLFetch: row: 1, column 1, bflsz: 4, bflar: SQL_NULL_DATA
              SQLFetch: row: 2, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 2, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 3, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 3, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 4, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 4, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 5, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 5, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 6, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 6, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 7, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 7, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 8, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 8, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 9, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 9, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 10, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 10, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 11, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 11, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 12, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 12, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 13, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 13, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 14, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 14, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 15, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 15, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 16, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 16, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 17, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 17, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 18, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 18, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 19, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 19, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 20, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 20, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 21, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 21, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 22, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 22, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 23, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 23, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 24, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 24, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 25, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 25, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 26, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 26, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 27, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 27, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 28, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 28, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 29, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 29, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 30, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 30, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 31, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 31, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 32, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 32, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 33, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 33, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 34, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 34, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 35, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 35, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 36, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 36, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 37, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 37, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 38, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 38, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 39, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 39, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 40, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 40, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 41, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 41, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 42, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 42, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 43, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 43, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 44, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 44, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 45, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 45, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 46, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 46, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 47, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 47, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 48, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 48, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 49, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 49, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 50, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 50, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 51, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 51, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 52, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 52, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 53, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 53, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 54, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 54, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 55, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 55, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 56, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 56, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 57, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 57, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 58, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 58, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 59, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 59, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 60, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 60, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 61, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 61, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 62, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 62, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 63, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 63, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 64, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 64, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 65, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 65, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 66, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 66, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 67, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 67, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 68, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 68, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 69, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 69, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 70, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 70, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 71, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 71, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 72, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 72, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 73, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 73, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 74, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 74, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 75, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 75, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 76, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 76, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 77, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 77, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 78, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 78, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 79, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 79, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 80, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 80, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 81, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 81, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 82, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 82, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 83, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 83, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 84, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 84, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 85, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 85, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 86, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 86, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 87, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 87, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 88, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 88, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 89, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 89, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 90, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 90, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 91, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 91, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 92, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 92, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 93, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 93, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 94, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 94, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 95, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 95, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 96, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 96, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 97, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 97, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 98, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 98, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 99, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 99, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              SQLFetch: row: 100, column 1, bflsz: 4, bflar: 0
              SQLFetch: row: 100, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
              100 rows fetched
              Exiting hgoftch, rc=0 at 2011/11/28-09:12:07
              hostmstr: 2050433024:      HOA After hoaftch
              hostmstr: 2050433024: RPC After Fetch Row
              hostmstr: 2050433024: RPC Before Commit Trans
              hostmstr: 2050433024:      HOA Before hoxclse
              Entered hgoclse, cursor id 1 at 2011/11/28-09:12:15
              Exiting hgoclse, rc=0 at 2011/11/28-09:12:15
              hostmstr: 2050433024:      HOA After hoxclse
              hostmstr: 2050433024:      HOA Before hoadafr
              Entered hgodafr, cursor id 1 at 2011/11/28-09:12:15
              Free hoada @ 02F5D3D4
              Exiting hgodafr, rc=0 at 2011/11/28-09:12:15
              hostmstr: 2050433024:      HOA After hoadafr
              hostmstr: 2050433024:      HOA Before hoacomm
              Entered hgocomm at 2011/11/28-09:12:15
              keepinfo:0, tflag:1
              00: 58452E38 31633633 6564392E 312E3231 [XE.81c63ed9.1.21]
              10: 2E333432 [.342]
              tbid (len 17) is ...
              00: 58455B31 2E32312E 3334325D 5B312E34 [XE[1.21.342][1.4]
              10: 5D []]
              cmt(0):
              Entered hgocpctx at 2011/11/28-09:12:15
              Exiting hgocpctx, rc=0 at 2011/11/28-09:12:15
              Exiting hgocomm, rc=0 at 2011/11/28-09:12:15
              hostmstr: 2050433024:      HOA After hoacomm
              hostmstr: 2050433024: RPC After Commit Trans
              hostmstr: 2050433024: RPC Before Logoff
              hostmstr: 2050433024:      HOA Before hoalgof
              Entered hgolgof at 2011/11/28-09:12:15
              tflag:1
              Exiting hgolgof, rc=0 at 2011/11/28-09:12:15
              hostmstr: 2050363392:      HOA After hoalgof
              hostmstr: 2050363392: RPC After Logoff
              hostmstr: 2050363392: RPC Before Exit Agent
              hostmstr: 2050363392:      HOA Before hoaexit
              Entered hgoexit at 2011/11/28-09:12:15
              Exiting hgoexit, rc=0
              hostmstr: 2053771264:      HOA After hoaexit
              hostmstr: 2053771264: RPC After Exit Agent
              • 4. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                Kgronau-Oracle
                There are a lot of issues with your odbc driver - it lacks some functionality:

                hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
                [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
                Exiting hgopoer, rc=0 at 2011/11/28-09:12:06
                hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00

                to analyze which kind of capability is missing an ODBC trace is required. Feel free to paste one to the thread.
                1 person found this helpful
                • 5. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                  Wile E. Coyote
                  This statement,

                  select NO_PROD, count (*) from bill_mat@dblink where NO_PROD in ('15','20', '24', '6','10') group by NO_PROD;

                  returns expected query result - no ORA-28528 occurs although same problematic column, "NO_PROD" is referenced. DG4ODBC trace file produced associated with executing this statement with expected result contains same references to "Driver not capable":

                  hgopoer, line 231: got native error 0 and sqlstate S1C00; message follows...
                  [Rocket U2][UVODBC][2701807]Driver not capable. {S1C00}
                  Exiting hgopoer, rc=0 at 2011/11/28-09:05:15
                  hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate S1C00

                  DG4ODBC requirement here is limited to "READ_ONLY" access to remote Rockit/UniVerse data source so I've hoped that any limitations of driver are related to functionality that I don't need such as distributed transactional support etc...

                  I noticed references to "Driver not capable" which made me wonder if there's some problem with this driver as well. However, there are no errors performing same retrieval using MS Excel/Access via MS Query using same system ODBC DSN and associated driver that is used for DG4ODBC access so from this I've reasoned that this driver is sufficient to meet DG4ODBC "READ_ONLY" requirement and that problem must be related to DG4ODBC configuration, character set specified, data mapping/conversion issue etc....

                  From what I can see it seems there may be some issue with the way NULL is represented between two systems. Ie., note that statement above works successfully referencing problematic column with WHERE clause that returns only non-NULL values. This is why I've tried different NLS_LANGUAGE settings but so far values attempted in addition to AMERICAN_AMERICA.WE8ISO8859P1 have had no effect - ORA-28528 has persisted.

                  I attempted to use Windows ODBC administrator to perform ODBC trace but no trace file is produced after I click button "Start Tracing Now" and perform DG4ODBC operation. The tracing DLL is C:\WINDOWS\system32\odbctrac.dll. A ODBC trace file is produced using this manner when I start tracing for drivers other than Rockit/UniVerse. As an alternative, there is a program called "Dr. Dee Bee Spy" that's provided by Rockit/UniVerse that it seems may be intended to produce ODBC trace. I've used this utility to produce ODBC trace and will provide associated with next post.

                  Regards, Glenn

                  Edited by: WileyCoyote on Mar 8, 2012 1:45 PM
                  • 6. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                    Wile E. Coyote
                    Here is output produced by utility "Dr. Dee Bee Spy" provided by Rockit/UniVerse that it seems may be intended to produce ODBC trace for Rockit/UniVerse ODBC driver:


                    SQLAllocEnv
                         0x01000000
                         SQL_SUCCESS
                    SQLAllocConnect
                         0x01000000
                         0x01010000
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_DRIVER_ODBC_VER
                         [5]02.00
                         12
                         5
                         SQL_SUCCESS
                    SQLSetConnectOption
                         0x01010000
                         SQL_AUTOCOMMIT
                         SQL_AUTOCOMMIT_OFF
                         SQL_SUCCESS
                    SQLDriverConnect
                         0x01010000
                         0x00000000
                         [36]DSN=DBLINK.ODBC;UID=Username;PWD=Password;
                         SQL_NTS
                         [36]DSN=DBLINK.ODBC;UID=Username;PWD=Password;
                         1024
                         36
                         SQL_DRIVER_NOPROMPT
                         SQL_SUCCESS
                    SQLError
                         NULL
                         0x01010000
                         NULL
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLGetFunctions
                         0x01010000
                         0
                         FALSE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         FALSE
                         TRUE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         FALSE
                         TRUE
                         FALSE
                         FALSE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         TRUE
                         FALSE
                         TRUE
                         TRUE
                         TRUE
                         FALSE
                         TRUE
                         TRUE
                         FALSE
                         TRUE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         FALSE
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_CURSOR_COMMIT_BEHAVIOR
                         SQL_CB_CLOSE
                         2
                         2
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_CURSOR_ROLLBACK_BEHAVIOR
                         SQL_CB_CLOSE
                         2
                         2
                         SQL_SUCCESS
                    SQLError
                         NULL
                         0x01010000
                         NULL
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         0x01010000
                         NULL
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLGetInfo
                         0x01010000
                         SQL_DRIVER_NAME
                         [10]UVODBC.DLL
                         1024
                         10
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_DRIVER_VER
                         [37]3.7 Universe RDBMS 32-bit ODBC Driver
                         1024
                         37
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_DBMS_NAME
                         [8]UniVerse
                         1024
                         8
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_DBMS_VER
                         [6]10.1.0
                         1024
                         6
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         10003
                         SQL_ERROR
                    SQLError
                         NULL
                         0x01010000
                         NULL
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2700830]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         0x01010000
                         NULL
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         0x01010000
                         NULL
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLGetInfo
                         0x01010000
                         SQL_OWNER_USAGE
                         0x00000000
                         4
                         4
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_TXN_CAPABLE
                         SQL_TC_DML
                         2
                         2
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_TXN_ISOLATION_OPTION
                         0x0F000000
                         4
                         4
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_MAX_OWNER_NAME_LEN
                         0
                         2
                         2
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_MAX_TABLE_NAME_LEN
                         72
                         2
                         2
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_MAX_PROCEDURE_NAME_LEN
                         0
                         2
                         2
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_IDENTIFIER_QUOTE_CHAR
                         [1]"
                         1024
                         1
                         SQL_SUCCESS
                    SQLGetInfo
                         0x01010000
                         SQL_COLUMN_ALIAS
                         [1]Y
                         1024
                         1
                         SQL_SUCCESS
                    SQLAllocStmt
                         0x01010000
                         0x01010001
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010001
                         1
                         SQL_C_CHAR
                         0x70EB1200
                         120
                         0xF4EF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010001
                         3
                         SQL_C_SLONG
                         0xDCEF1200
                         0
                         0xE4EF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010001
                         10
                         SQL_C_SSHORT
                         0x0CF01200
                         0
                         0xECEF1200
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_VARCHAR
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_INTEGER
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_SMALLINT
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_VARBINARY
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_BIGINT
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_TINYINT
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_LONGVARCHAR
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLGetTypeInfo
                         0x01010001
                         SQL_LONGVARBINARY
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010001
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010001
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010001
                         SQL_UNBIND
                         SQL_SUCCESS
                    SQLTransact
                         NULL
                         0x01010000
                         SQL_COMMIT
                         SQL_SUCCESS
                    SQLSetConnectOption
                         0x01010000
                         SQL_TXN_ISOLATION
                         SQL_TXN_READ_COMMITTED
                         SQL_SUCCESS
                    SQLAllocStmt
                         0x01010000
                         0x01010002
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010001
                         SQL_DROP
                         SQL_SUCCESS
                    SQLAllocStmt
                         0x01010000
                         0x01010003
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         4
                         SQL_C_CHAR
                         0xD8EE1200
                         124
                         0x9CEF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         5
                         SQL_C_SSHORT
                         0xECEF1200
                         0
                         0x00000000
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         6
                         SQL_C_CHAR
                         0x60EE1200
                         120
                         0xC8EF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         7
                         SQL_C_SLONG
                         0xA4EF1200
                         0
                         0xA8EF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         9
                         SQL_C_SSHORT
                         0xF0EF1200
                         0
                         0xB0EF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         10
                         SQL_C_SSHORT
                         0xF8EF1200
                         0
                         0xD0EF1200
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         11
                         SQL_C_SSHORT
                         0xF4EF1200
                         0
                         0x00000000
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010003
                         16
                         SQL_C_SLONG
                         0xB8EF1200
                         0
                         0xBCEF1200
                         SQL_SUCCESS
                    SQLColumns
                         0x01010003
                         NULL
                         0
                         NULL
                         0
                         [8]BILL_MAT
                         8
                         NULL
                         0
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010003
                         SQL_FETCH_NEXT
                         0
                         NULL
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010003
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010003
                         SQL_UNBIND
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010003
                         SQL_DROP
                         SQL_SUCCESS
                    SQLAllocStmt
                         0x01010000
                         0x01010004
                         SQL_SUCCESS
                    SQLPrepare
                         0x01010004
                         [24]select * from "BILL_MAT"
                         24
                         SQL_SUCCESS
                    SQLNumResultCols
                         0x01010004
                         27
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         1
                         [4]Z_ID
                         31
                         4
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         1
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         2
                         [9]A_PROD_NO
                         31
                         9
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         2
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         3
                         [9]BATCH_QTY
                         31
                         9
                         SQL_INTEGER
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         3
                         SQL_COLUMN_UNSIGNED
                         UNUSED
                         UNUSED
                         UNUSED
                         FALSE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         4
                         [8]COST_UPD
                         31
                         8
                         SQL_DATE
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         5
                         [9]CREATE_DT
                         31
                         9
                         SQL_DATE
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         6
                         [5]LABOR
                         31
                         5
                         SQL_NUMERIC
                         8
                         4
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         7
                         [4]LOCK
                         31
                         4
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         7
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         8
                         [7]LST_CST
                         31
                         7
                         SQL_NUMERIC
                         7
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         9
                         [8]LST_PROD
                         31
                         8
                         SQL_DATE
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         10
                         [6]LST_WO
                         31
                         6
                         SQL_INTEGER
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         10
                         SQL_COLUMN_UNSIGNED
                         UNUSED
                         UNUSED
                         UNUSED
                         FALSE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         11
                         [7]NO_PROD
                         31
                         7
                         SQL_INTEGER
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         11
                         SQL_COLUMN_UNSIGNED
                         UNUSED
                         UNUSED
                         UNUSED
                         FALSE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         12
                         [3]P_C
                         31
                         3
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         12
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         13
                         [5]PRICE
                         31
                         5
                         SQL_NUMERIC
                         4
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         14
                         [9]PROD_DESC
                         31
                         9
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         14
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         15
                         [13]PROD_DESC_QTY
                         31
                         13
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         15
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         16
                         [9]PROD_NAME
                         31
                         9
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         16
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         17
                         [6]P_NAME
                         31
                         6
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         17
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         18
                         [3]QTY
                         31
                         3
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         18
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         19
                         [8]STOCK_UM
                         31
                         8
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         19
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         20
                         [8]TOT_COST
                         31
                         8
                         SQL_NUMERIC
                         8
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         21
                         [9]TOT_COST4
                         31
                         9
                         SQL_NUMERIC
                         8
                         4
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         22
                         [14]TOT_LABOR_COST
                         31
                         14
                         SQL_NUMERIC
                         8
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         23
                         [13]TOT_LABOR_HRS
                         31
                         13
                         SQL_NUMERIC
                         8
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         24
                         [12]TOT_MAT_COST
                         31
                         12
                         SQL_NUMERIC
                         8
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         25
                         [13]TOT_OVHD_COST
                         31
                         13
                         SQL_NUMERIC
                         8
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010004
                         26
                         [2]UM
                         31
                         2
                         SQL_VARCHAR
                         254
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010004
                         26
                         1013
                         SQL_ERROR
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]S1C00
                         0
                         [47][Rocket U2][UVODBC][2701807]Driver not capable.
                         512
                         47
                         SQL_SUCCESS
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]00000
                         0
                         [0]
                         512
                         0
                         SQL_NO_DATA_FOUND
                    SQLDescribeCol
                         0x01010004
                         27
                         [6]YIELD_
                         31
                         6
                         SQL_NUMERIC
                         3
                         2
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLCancel
                         0x01010004
                         SQL_SUCCESS_WITH_INFO
                    SQLError
                         NULL
                         NULL
                         0x01010004
                         [5]01S05
                         0
                         [60][Rocket U2][UVODBC][2701402]Cancel treated as FreeStmt/CLOSE
                         512
                         60
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010004
                         SQL_CLOSE
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010002
                         SQL_DROP
                         SQL_SUCCESS
                    SQLAllocStmt
                         0x01010000
                         0x01010005
                         SQL_SUCCESS
                    SQLPrepare
                         0x01010005
                         [32]SELECT "NO_PROD" FROM "BILL_MAT"
                         32
                         SQL_SUCCESS
                    SQLNumResultCols
                         0x01010005
                         1
                         SQL_SUCCESS
                    SQLDescribeCol
                         0x01010005
                         1
                         [7]NO_PROD
                         31
                         7
                         SQL_INTEGER
                         10
                         0
                         SQL_NULLABLE
                         SQL_SUCCESS
                    SQLColAttributes
                         0x01010005
                         1
                         SQL_COLUMN_UNSIGNED
                         UNUSED
                         UNUSED
                         UNUSED
                         FALSE
                         SQL_SUCCESS
                    SQLSetStmtOption
                         0x01010005
                         SQL_ROWSET_SIZE
                         0x64000000
                         SQL_SUCCESS
                    SQLSetStmtOption
                         0x01010005
                         SQL_BIND_TYPE
                         SQL_BIND_BY_COLUMN
                         SQL_SUCCESS
                    SQLExecute
                         0x01010005
                         SQL_SUCCESS
                    SQLBindCol
                         0x01010005
                         1
                         SQL_C_SLONG
                         0xD89BF702
                         4
                         0x149FF702
                         SQL_SUCCESS
                    SQLExtendedFetch
                         0x01010005
                         SQL_FETCH_NEXT
                         0
                         0
                         SQL_NO_DATA_FOUND
                    SQLFreeStmt
                         0x01010005
                         SQL_UNBIND
                         SQL_SUCCESS
                    SQLFreeStmt
                         0x01010005
                         SQL_DROP
                         SQL_SUCCESS
                    SQLTransact
                         NULL
                         0x01010000
                         SQL_COMMIT
                         SQL_SUCCESS

                    Edited by: WileyCoyote on Mar 8, 2012 1:46 PM
                    • 7. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                      Kgronau-Oracle
                      Downloaded Universe for Windows and reproduced the issue. Investigating

                      Edited by: kgronau on Nov 29, 2011 12:38 PM

                      delete from kgr1@universe;
                      0 rows deleted.
                      commit;
                      commited.
                      insert into kgr1@universe values(9);
                      1 rows inserted.
                      select * from KGR1@universe;

                      COL1
                      ----------------------
                      9

                      insert into kgr1@universe values(NULL);
                      1 rows inserted.

                      select * from KGR1@universe;
                      Error starting at line 17 in command:
                      select * from KGR1@universe
                      Error report:
                      SQL Error: ORA-28528: Heterogeneous Services datatype conversion error
                      1 person found this helpful
                      • 8. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                        Kgronau-Oracle
                        DG4ODBC traces show a buffer issue.

                        When I select the inserted value 9 the table structure/buffer looks like:
                        DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                        4 INTEGER Y 4 4 0/ 0 0 0 0 COL1
                        Performing delayed open.
                        SQLBindCol: column 1, cdatatype: -16, bflsz: 4
                        SQLFetch: row: 1, column 1, bflsz: 4, bflar: 4
                        SQLFetch: row: 1, column 1, bflsz: 4, bflar: 4, (bfl: 4, mbl: 4)
                        1 rows fetched

                        When I try to select the value 9 and NULL the trace looks different:
                        DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                        4 INTEGER Y 4 4 0/ 0 0 0 0 COL1
                        Performing delayed open.
                        SQLBindCol: column 1, cdatatype: -16, bflsz: 4
                        SQLFetch: row: 1, column 1, bflsz: 4, bflar: -1
                        SQLFetch: row: 1, column 1, bflsz: 4, bflar: SQL_NULL_DATA
                        SQLFetch: row: 2, column 1, bflsz: 4, bflar: 0
                        SQLFetch: row: 2, column 1, bflsz: 4, bflar: 0, (bfl: 4, mbl: 4)
                        2 rows fetched

                        The NULL value is correct, but the value 9 uses bflar:0 instead of 4 when selecting the table without a null value.


                        Analyzing ODBC traces
                        1 person found this helpful
                        • 9. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                          Kgronau-Oracle
                          There's a buffer issue in the ODBC driver which causes problems when using bulk fetch (which is the default of dg4odbc).

                          I've made sure that no dg4odbc process is running anymore in my env, then I've added to the gateway init file: HS_FDS_FETCh_ROWS=1


                          Now I'm able to successfully select the table:
                          set null <NULL>

                          SQL> select * from KGR1@universe;

                          COL1
                          ----------
                          9
                          <NULL>


                          => so please add HS_FDS_FETCh_ROWS=1 to your gateway init file as well, then check again.

                          Edited by: kgronau on Nov 29, 2011 1:47 PM
                          1 person found this helpful
                          • 10. Re: DG4ODBC configured and working but receiving ORA-28528 for some columns
                            Wile E. Coyote
                            That was one fine bit of troubleshooting my friend! I added HS_FD_FETCH_ROWS=1 to configuration file and that resolved all the issues with problematic columns identified with subject tables I've been focusing on:


                            MAX:27, ACTUAL:27, BRC:100, WHT=5 (SELECT_LIST)
                            hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
                            DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 Z_ID
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 A_PROD_NO
                            4 INTEGER Y 4 4 0/ 0 0 0 0 BATCH_QTY          ----------------> only case where mapped-to datatype is integer where ORA-28528 did not occur!
                            91 DATE Y 16 16 0/ 0 0 0 0 COST_UPD
                            91 DATE Y 16 16 0/ 0 0 0 0 CREATE_DT
                            3 DECIMAL Y 11 11 8/ 4 0 0 0 LABOR
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 LOCK
                            3 DECIMAL Y 10 10 7/ 2 0 0 0 LST_CST
                            91 DATE Y 16 16 0/ 0 0 0 0 LST_PROD
                            4 INTEGER Y 4 4 0/ 0 0 0 0 LST_WO          ----------------> problematic field
                            4 INTEGER Y 4 4 0/ 0 0 0 0 NO_PROD          ----------------> problematic field
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 P_C
                            3 DECIMAL Y 7 7 4/ 2 0 0 0 PRICE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_DESC
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_DESC_QTY
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_NAME
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 P_NAME
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 QTY
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 STOCK_UM
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_COST
                            3 DECIMAL Y 11 11 8/ 4 0 0 0 TOT_COST4
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_LABOR_COST
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_LABOR_HRS
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_MAT_COST
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 TOT_OVHD_COST
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 UM
                            3 DECIMAL Y 6 6 3/ 2 0 0 0 YIELD_

                            MAX:108, ACTUAL:108, BRC:100, WHT=5 (SELECT_LIST)
                            hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
                            DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 Z_ID
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 ACCEPT_BO
                            3 DECIMAL Y 16 16 13/ 2 0 0 0 AVG_COST
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 A_CUST_NO
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 A_PROD_NO
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 BLANKET_PO
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 BLOCK_TIER
                            4 INTEGER Y 4 4 0/ 0 0 0 0 BOX_QTY          ----------------> problematic field
                            4 INTEGER Y 4 4 0/ 0 0 0 0 CASE_QTY          ----------------> problematic field
                            3 DECIMAL Y 9 9 6/ 4 0 0 0 CASH_
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 CATALOG_PRODUCT
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 CAT_PAGE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 COMBO_CODE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 CONTROL_DRUG
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 COUNTRY_DESC
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 COUNTRY_ORIGIN
                            91 DATE Y 16 16 0/ 0 0 0 0 CREATE_DT
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 CRITICAL_ROP
                            91 DATE Y 16 16 0/ 0 0 0 0 CST_DAT
                            3 DECIMAL Y 16 16 13/ 2 0 0 0 CURR_COST
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DEA_TYPE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DESC_1
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DESC_2
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DISCONTINUED
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DISCOUNTABLE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DISC_BRK_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DISPOSITION
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 DROP_SHIP_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 EXP_DAT_REQ
                            3 DECIMAL Y 7 7 4/ 2 0 0 0 FRT_CHG
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 GROUP_NO
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 INTL_DESC
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 KIT_IND
                            4 INTEGER Y 4 4 0/ 0 0 0 0 LEAD_TIME          ----------------> problematic field
                            3 DECIMAL Y 16 16 14/ 0 0 0 0 LIST_PRICE
                            91 DATE Y 16 16 0/ 0 0 0 0 LST_PRC_CHG
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 MARK_UP_PCT
                            3 DECIMAL Y 16 16 13/ 2 0 0 0 MAXGP
                            3 DECIMAL Y 16 16 13/ 2 0 0 0 MAX_AVG_WGT
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 MDS_FLAG
                            3 DECIMAL Y 13 13 10/ 2 0 0 0 MIN_AVG_WGT
                            3 DECIMAL Y 9 9 6/ 2 0 0 0 MIN_GP
                            4 INTEGER Y 4 4 0/ 0 0 0 0 MIN_PO_QTY          ----------------> problematic field
                            4 INTEGER Y 4 4 0/ 0 0 0 0 MIN_QTY          ----------------> problematic field
                            4 INTEGER Y 4 4 0/ 0 0 0 0 MIN_SOLD          ----------------> problematic field
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 MNF_PROD_
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 NDC_
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 NSN_
                            3 DECIMAL Y 10 10 7/ 2 0 0 0 OLD_CST
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 OWN_CO_
                            4 INTEGER Y 4 4 0/ 0 0 0 0 P_C               ----------------> problematic field
                            4 INTEGER Y 4 4 0/ 0 0 0 0 P_T               ----------------> problematic field
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PARTS_CODE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PART_SHIP
                            3 DECIMAL Y 16 16 13/ 4 0 0 0 PCK_CB
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PO_COMBO_CODE
                            3 DECIMAL Y 14 14 11/ 2 0 0 0 PO_COST
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PO_GROUP
                            4 INTEGER Y 4 4 0/ 0 0 0 0 PRC_MULT          ----------------> problematic field
                            4 INTEGER Y 4 4 0/ 0 0 0 0 PRC_QTY          ----------------> problematic field
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PRC_UM
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PREF_ITEM_SELL
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_CLASS
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_LINE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PROD_NO
                            4 INTEGER Y 4 4 0/ 0 0 0 0 PROD_TYPE          ----------------> problematic field
                            91 DATE Y 16 16 0/ 0 0 0 0 PROMO_BEGDT
                            91 DATE Y 16 16 0/ 0 0 0 0 PROMO_ENDDT
                            3 DECIMAL Y 10 10 7/ 2 0 0 0 PROMO_PRICE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PURCH_AGENT
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PURCH_AGT
                            4 INTEGER Y 4 4 0/ 0 0 0 0 PURCH_QTY          ----------------> problematic field
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 PURCH_UM
                            3 DECIMAL Y 11 11 8/ 2 0 0 0 QTY_FACTOR
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 QUALIFY_FREE_FRT
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 RANK
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 REBATABLE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 REQ_DS_FLAG
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SEASONAL
                            4 INTEGER Y 4 4 0/ 0 0 0 0 SELL_QTY          ----------------> problematic field
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SELL_UM
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SERIAL
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SERIAL_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SHIP_QTY_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SHOW_COST
                            3 DECIMAL Y 16 16 13/ 2 0 0 0 STD_COST
                            3 DECIMAL Y 10 10 7/ 2 0 0 0 STD_CST
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 STK_STAT_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 STOCK_FLAG
                            3 DECIMAL Y 13 13 11/ 0 0 0 0 STOCK_QTY
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 STOCK_UM
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SUB_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SUB_PRC_IND
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 SUPPLY_METHOD
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 TAXABLE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 TEMP_ITEM
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 UM
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 UNIT_PK
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 UPC_CODE
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 VEND_NAME
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 VEND_NO
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 VND_PROD
                            4 INTEGER Y 4 4 0/ 0 0 0 0 WARRANTY          ----------------> problematic field
                            3 DECIMAL Y 8 8 5/ 1 0 0 0 WEIGHT
                            12 VARCHAR Y 254 254 0/ 0 0 0 200 WH
                            3 DECIMAL Y 13 13 10/ 2 0 0 0 YR_AVG_COST
                            3 DECIMAL Y 21 21 18/ 2 0 0 0 YR_LST_CST
                            3 DECIMAL Y 21 21 18/ 2 0 0 0 YR_STD_CST


                            The one definitive common denominator I'd been able to identify had been that problematic columns use integer datatype. However, ORA-28528 did not occur in the case of column BATCH_QTY of first table above of type integer. One thing that seemed to set this particular column apart from others of type integer was that no NULL values exist for BATCH_QTY:

                            1* select batch_qty, count (*) from bill_mat@DBLINK group by batch_qty
                            SQL> /

                            BATCH_QTY COUNT(*)
                            ======== ======
                            1 383

                            Hence, reason for thinking this may represent some issue with characterset. Thanks so much for confirming NULL as a relevant factor in conjunction with buffer handling as opposed to languange setting!

                            You are guru! :-)

                            Edited by: WileyCoyote on Mar 8, 2012 1:49 PM