1 2 3 Previous Next 34 Replies Latest reply: Feb 26, 2013 4:00 AM by Luan Huynh Go to original post RSS
      • 30. Re: Database Link ORACLE to POSTGRESQL.
        Luan Huynh
        1/ initpsqltest.ora
        HS_FDS_CONNECT_INFO = DNS_PSQL
        HS_FDS_TRACE_LEVEL = 255
        HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so
        HS_NLS_NCHAR = UCS2
        HS_LANGUAGE=american_america.we8iso8859p1
        set ODBCINI= /usr/local/etc/odbc.ini


        2/ Ouput hs/log
        ---------------------------------------------------------------------------------------------------------------------------------------------------------
        ---------------------------------------------------------------------------------------------------------------------------------------------------------


        Oracle Corporation --- SATURDAY FEB 23 2013 17:27:45.687


        Heterogeneous Agent Release
        11.2.0.1.0




        Oracle Corporation --- SATURDAY FEB 23 2013 17:27:45.687

        Version 11.2.0.1.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"
        HOSGIP returned value of "UCS2" for HS_NLS_NCHAR
        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_CHARACTER_SEMANTICS to default of "FALSE"
        setting HS_FDS_MAP_NCHAR to default of "TRUE"
        setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
        setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
        setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
        setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
        setting HS_FDS_QUERY_DRIVER to default of "TRUE"
        setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
        Parameter HS_FDS_QUOTE_IDENTIFIER is not set
        setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
        setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
        setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
        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 "psqltest"
        Product-Info:
        Port Rls/Upd:1/0 PrdStat:0
        Agent:Oracle Database Gateway for ODBC
        Facility:hsa
        Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:psqltest
        Exiting hgogprd, rc=0
        hostmstr: 0:      HOA After hoagprd
        hostmstr: 0:      HOA Before hoainit
        Entered hgoinit
        HOCXU_COMP_CSET=1
        HOCXU_DRV_CSET=31
        HOCXU_DRV_NCHAR=1000
        HOCXU_DB_CSET=873
        HOCXU_SEM_VER=112000
        Entered hgolofn at 2013/02/23-17:27:45
        HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib/libodbc.so"
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLAllocHandle
        symbol_peflctx=0x44d4f0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLBindCol
        symbol_peflctx=0x44d690
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLBindParameter
        symbol_peflctx=0x44e0e0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLCancel
        symbol_peflctx=0x44f8e0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLDescribeParam
        symbol_peflctx=0x4591f0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLDisconnect
        symbol_peflctx=0x459780
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLEndTran
        symbol_peflctx=0x45c880
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLExecute
        symbol_peflctx=0x45e440
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLFetch
        symbol_peflctx=0x45edd0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLFreeHandle
        symbol_peflctx=0x460f30
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLFreeStmt
        symbol_peflctx=0x460f60
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetData
        symbol_peflctx=0x462cc0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetEnvAttr
        symbol_peflctx=0x466920
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetFunctions
        symbol_peflctx=0x466d20
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLMoreResults
        symbol_peflctx=0x468db0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLNumResultCols
        symbol_peflctx=0x469cd0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLParamData
        symbol_peflctx=0x46a090
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLPutData
        symbol_peflctx=0x46c6d0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLRowCount
        symbol_peflctx=0x46cbc0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLSetEnvAttr
        symbol_peflctx=0x46f570
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLSetDescRec
        symbol_peflctx=0x46f2f0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLColAttribute
        symbol_peflctx=0x450450
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLColumns
        symbol_peflctx=0x452350
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLConnect
        symbol_peflctx=0x456670
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLDescribeCol
        symbol_peflctx=0x458910
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLDriverConnect
        symbol_peflctx=0x45a540
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLExecDirect
        symbol_peflctx=0x45dd80
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLForeignKeys
        symbol_peflctx=0x45f910
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetConnectAttr
        symbol_peflctx=0x4613c0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetDescField
        symbol_peflctx=0x4634f0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetDescRec
        symbol_peflctx=0x463b90
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetDiagField
        symbol_peflctx=0x465030
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetDiagRec
        symbol_peflctx=0x465f00
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetInfo
        symbol_peflctx=0x4678b0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetStmtAttr
        symbol_peflctx=0x467c40
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLGetTypeInfo
        symbol_peflctx=0x468920
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLPrepare
        symbol_peflctx=0x46a970
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLPrimaryKeys
        symbol_peflctx=0x46afd0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLProcedureColumns
        symbol_peflctx=0x46b770
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLProcedures
        symbol_peflctx=0x46bf90
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLSetConnectAttr
        symbol_peflctx=0x46cf00
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLSetStmtAttr
        symbol_peflctx=0x470de0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLSetDescField
        symbol_peflctx=0x46ee50
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLStatistics
        symbol_peflctx=0x472ed0
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Entered hgolofns at 2013/02/23-17:27:45
        libname=/usr/lib/libodbc.so, funcname=SQLTables
        symbol_peflctx=0x473f40
        hoaerr:0
        Exiting hgolofns at 2013/02/23-17:27:45
        Exiting hgolofn, rc=0 at 2013/02/23-17:27:45
        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 2013/02/23-17:27:45
        hostmstr: 0:      HOA After hoainit
        hostmstr: 0:      HOA Before hoalgon
        Entered hgolgon at 2013/02/23-17:27:45
        reco:0, name:postgres, tflag:0
        Entered hgosuec at 2013/02/23-17:27:45
        Exiting hgosuec, rc=0 at 2013/02/23-17:27:45
        HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
        HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
        HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
        HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
        HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
        HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
        HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
        HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
        HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
        HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
        using postgres as default value for "HS_FDS_DEFAULT_OWNER"
        HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
        Entered hgocont at 2013/02/23-17:27:45
        HS_FDS_CONNECT_INFO = "DNS_PSQL"
        RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
        Entered hgogenconstr at 2013/02/23-17:27:45
        dsn:DNS_PSQL, name:postgres
        optn:
        Entered hgocip at 2013/02/23-17:27:45
        dsn:DNS_PSQL
        Exiting hgocip, rc=0 at 2013/02/23-17:27:45
        ##>Connect Parameters (len=37)<##
        ## DSN=DNS_PSQL;
        #! UID=postgres;
        #! PWD=*
        Exiting hgogenconstr, rc=0 at 2013/02/23-17:27:45
        Entered hgopoer at 2013/02/23-17:27:45
        hgopoer, line 233: got native error 0 and sqlstate 01000; message follows...
        [unixODBC][Driver Manager]Driver does not support the requested version {01000}
        Exiting hgopoer, rc=0 at 2013/02/23-17:27:45
        hgocont, line 2685: calling SqlDriverConnect got sqlstate 01000
        Entered hgolosf at 2013/02/23-17:27:45
        ODBC Function-Available-Array 0xFFFE 0x00FF 0xFF00 0xFA7F 0x03B2 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 0xA400 0x114C
        Exiting hgolosf, rc=0 at 2013/02/23-17:27:45
        DriverName:libpsqlodbc.so, DriverVer:07.01.0003
        DBMS Name:PostgreSQL, DBMS Version:07.01.0003 PostgreSQL 9.0.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 32-bit
        Exiting hgocont, rc=0 at 2013/02/23-17:27:45 with error ptr FILE:hgocont.c LINE:2685 FUNCTION:hgocont() ID:SQLDriverConnect
        Entered hgopoer at 2013/02/23-17:27:45
        hgopoer, line 233: got native error 209 and sqlstate HYC00; message follows...
        Unrecognized key passed to SQLGetInfo. {HYC00,NativeErr = 209}
        Exiting hgopoer, rc=0 at 2013/02/23-17:27:45
        hgolgon, line 795: calling SQLGetInfo got sqlstate HYC00
        SQLGetInfo returns N for SQL_CATALOG_NAME
        Exiting hgolgon, rc=0 at 2013/02/23-17:27:45 with error ptr FILE:hgolgon.c LINE:795 FUNCTION:hgolgon() ID:GetInfo: Support catalogs
        hostmstr: 0:      HOA After hoalgon
        RPC Calling nscontrol(0), rc=0
        hostmstr: 0: RPC Before Upload Caps
        hostmstr: 0:      HOA Before hoaulcp
        Entered hgoulcp at 2013/02/23-17:27:45
        Entered hgowlst at 2013/02/23-17:27:45
        Exiting hgowlst, rc=0 at 2013/02/23-17:27:45
        SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
        TXN Capable:2, Isolation Option:0x2
        SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
        SQLGetInfo returns 32 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 N for SQL_COLUMN_ALIAS
        4 instance capabilities will be uploaded
        capno:1964, context:0x00000000, add-info: 0
        capno:1989, context:0x00000000, add-info: 0
        capno:1991, context:0x00000000, add-info: 0
        capno:1992, context:0x0001ffff, add-info: 0
        Exiting hgoulcp, rc=0 at 2013/02/23-17:27:45
        hostmstr: 0:      HOA After hoaulcp
        hostmstr: 0: RPC After Upload Caps
        hostmstr: 0: RPC Before Upload DDTR
        hostmstr: 0:      HOA Before hoauldt
        Entered hgouldt at 2013/02/23-17:27:45
        NO instance DD translations were uploaded
        Exiting hgouldt, rc=0 at 2013/02/23-17:27:45
        hostmstr: 0:      HOA After hoauldt
        hostmstr: 0: RPC After Upload DDTR
        hostmstr: 0: RPC Before Begin Trans
        hostmstr: 0:      HOA Before hoabegn
        Entered hgobegn at 2013/02/23-17:27:45
        tflag:0 , initial:1
        hoi:0xbfc95aa0, ttid (len 23) is ...
        00: 4F52434C 2E613530 36336565 342E362E [ORCL.a5063ee4.6.]
        10: 32372E34 383731 [27.4871]
        tbid (len 20) is ...
        00: 4F52434C 5B362E32 372E3438 37315D5B [ORCL[6.27.4871][]
        10: 312E345D [1.4]]
        Exiting hgobegn, rc=0 at 2013/02/23-17:27:45
        hostmstr: 0:      HOA After hoabegn
        hostmstr: 0: RPC After Begin Trans
        hostmstr: 0: RPC Before Describe Table
        hostmstr: 0:      HOA Before hoadtab
        Entered hgodtab at 2013/02/23-17:27:45
        count:1
        table: DUAL
        Allocate hoada[0] @ 0x9dae06c
        Free hoada[0] @ 0x9dae06c
        Entered hgopdsc at 2013/02/23-17:27:45
        Describing procedure DUAL
        Output hoada
        hgopdsc, line 1406: NO hoada to print
        Exiting hgopdsc, rc=942 at 2013/02/23-17:27:45
        The hoada for table DUAL follows...
        hgodtab, line 876: NO hoada to print
        Exiting hgodtab, rc=0 at 2013/02/23-17:27:45
        hostmstr: 0:      HOA After hoadtab
        hostmstr: 0: RPC After Describe Table
        hostmstr: 0: RPC Before SQL Bundling
        hostmstr: 0:      HOA Before hoxpars
        Entered hgopars, cursor id 1 at 2013/02/23-17:27:45
        type:0
        SQL text from hgopars, id=1, len=20 ...
        00: 53454C45 4354202A 2046524F 4D202244 [SELECT * FROM "D]
        10: 55414C22 [UAL"]
        Exiting hgopars, rc=28500 at 2013/02/23-17:27:45 with error ptr FILE:hgopars.c LINE:570 FUNCTION:hgopars() ID:SELECT list of size 0 is not valid
        hostmstr: 0:      HOA After hoxpars
        hostmstr: 0: RPC After SQL Bundling
        hostmstr: 0: RPC Before SQL Bundling
        hostmstr: 0:      HOA Before hoxpars
        Entered hgopars, cursor id 1 at 2013/02/23-17:27:45
        type:0
        SQL text from hgopars, id=1, len=20 ...
        00: 53454C45 4354202A 2046524F 4D202244 [SELECT * FROM "D]
        10: 55414C22 [UAL"]
        Exiting hgopars, rc=28500 at 2013/02/23-17:27:45 with error ptr FILE:hgopars.c LINE:570 FUNCTION:hgopars() ID:SELECT list of size 0 is not valid
        hostmstr: 0:      HOA After hoxpars
        hostmstr: 0: RPC After SQL Bundling

        ---------------------------------------------------------------------------------------------------------------------------------------------------------
        ---------------------------------------------------------------------------------------------------------------------------------------------------------
        • 31. Re: Database Link ORACLE to POSTGRESQL.
          Kgronau-Oracle
          The ODBC driver you are using is an old ODBC driver and the error message in the gateway trace indicates an issue with the ODBC driver (00: 53454C45 4354202A 2046524F 4D202244 [SELECT * FROM "D]
          10: 55414C22 [UAL"]
          Exiting hgopars, rc=28500 at 2013/02/23-17:27:45 with error ptr FILE:hgopars.c LINE:570 FUNCTION:hgopars() ID:SELECT list of size 0 is not valid)


          We could now generate an ODBC trace file to see which ODBC function is failing in detail, but as the PostgreSQL ODBC driver you're using is V7 (DriverName:libpsqlodbc.so, DriverVer:07.01.0003) it would be better to update the driver to V9.1 release.

          - Klaus
          • 32. Re: Database Link ORACLE to POSTGRESQL.
            Luan Huynh
            Thanks kgronau!
            I finding !!!
            But why you think "driver to V9.1 release." is ok ??? :D
            • 33. Re: Database Link ORACLE to POSTGRESQL.
              Kgronau-Oracle
              I've installed a V9.1 driver which at least allows me to perform basic stuff with DG4ODBC - it is still not optimal, but works for most cases.
              • 34. Re: Database Link ORACLE to POSTGRESQL.
                Luan Huynh
                Thanks !
                Although I haven't installed v.9 yet !
                Your guide is very helpful with me. Until now, I think I can resolve my problems.
                Thanks a lot !
                Regard,
                Luan !

                Edited by: Luan Huynh on 02:00 26-02-2013
                1 2 3 Previous Next