This discussion is archived
1 2 3 Previous Next 34 Replies Latest reply: Feb 26, 2013 2:00 AM by Luan Huynh Go to original post RSS
  • 30. Re: Database Link ORACLE to POSTGRESQL.
    Luan Huynh Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks kgronau!
    I finding !!!
    But why you think "driver to V9.1 release." is ok ??? :D
  • 33. Re: Database Link ORACLE to POSTGRESQL.
    kgronau Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points