This discussion is archived
1 2 3 Previous Next 40 Replies Latest reply: Oct 9, 2013 10:51 PM by user13573211 Go to original post RSS
  • 30. Re: ORACLE to POSTGRES db link not working
    user13573211 Newbie
    Currently Being Moderated

    Let me post those file also::

     

    [oracle@scflsdb001 admin]$ cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini

    [postgresql]

    Description             = psqlodbc regression test DSN

    Driver                          = /home/oracle/temp/psqlodbc-09.02.0100/.libs/psqlodbcw.so

    Trace                       = Yes

    TraceFile               = /home/oracle/tmp/sql.log

    Database                = *********

    Servername              = devpgres00.office.corp

    Username                = ********

    Password                = **********

    Port                        = 5432

    Protocol                = 6.4

    ReadOnly                = No

    RowVersioning           = No

    ShowSystemTable         = No

    ShowOidColumn           = No

    FakeOidIndex            = No

    ConnSettings            =

    [oracle@scflsdb001 admin]$

     

    [oracle@scflsdb001 admin]$ cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini

    [psqlodbc]

    Description     = PostgreSQL ODBC driver (Unicode version), for regression tests

    Driver          = ../.libs/psqlodbcw.so

    Debug           = 0

    CommLog         = 1

    [oracle@scflsdb001 admin]$

  • 31. Re: ORACLE to POSTGRES db link not working
    kgronau Guru
    Currently Being Moderated

    the error is:

     

    Unable to open init file initpostgresql.ora in directory /oracle/database/11.2.0.3/hs/admin

    HS Gateway:  NULL connection context at exit

     

     

    In one of the first threads you stated your gateway init file is:

    /oracle/database/11.2.0.3/hs/admin/initdg4odbc.ora

     

    But the listener SID is postgresql ((SID_NAME = postgresql))

    So please rename initdg4odbc.ora to initpostgresql.ora

     

    BTW, did you already change the HS_FDS_SHAREABLE_NAME parameter so that it now refers to the 64bit Driver Manager?

    According to another thread -> yes, but cross check that again.

    It should be similar to HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so

     

    - Klaus

  • 32. Re: ORACLE to POSTGRES db link not working
    user13573211 Newbie
    Currently Being Moderated

    Finally it looks like it is working....

     

    SQL> select * from "shopping_list"@pg_link1;               

    select * from "shopping_list"@pg_link1

                  *

    ERROR at line 1:

    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

    ERROR:  relation "shopping_list" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    ORA-02063: preceding 3 lines from PG_LINK1

     

    But I dont know any table name in the POSTGRES DB, is there any way that I can know the POSTGRES table..?? SO that I can test the link..??

  • 33. Re: ORACLE to POSTGRES db link not working
    kgronau Guru
    Currently Being Moderated

    there are queries to check objects at the foreign database - unfortunately not all work with foreign databases all the time.

    Try:

    select user from dual@pg_link1;

    dual is an Oracle table and when t does not exist at the foreign database the gateway will use internal mechanisms to return a result. But that would require that the ODBC driver returns a correct error code (like table does not exist) which then triggers the internal gateway mechanism. That does not always work using a gateway with foreign ODBC drivers, but works very often and is worth to check.

     

    Then check:

    select * from all_catalog@pg_link1;

    also all_catalog will use internal mechanisms to get a result and when it works, then it reports a list of available objects in the foreign Postgres database.

     

     

    Finally ask the Postgres admin which object you can select. Take care about the object name, it might be case sensitive. So write it as it is in the select statement and make sure to surround it by double quotes.

  • 34. Re: ORACLE to POSTGRES db link not working
    user13573211 Newbie
    Currently Being Moderated

    I have got errors for every try...Can I really trust that my connection is working....?? what tells me that my connection is working..???

     

    SQL> select user from dual@pg_link1;

    select user from dual@pg_link1

                     *

    ERROR at line 1:

    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

    ERROR:  relation "DUAL" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    ORA-02063: preceding 3 lines from PG_LINK1

     

     

     

     

    SQL> select * from all_catalog@pg_link1;

    select * from all_catalog@pg_link1

                  *

    ERROR at line 1:

    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

    ERROR:  relation "ALL_CATALOG" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    ORA-02063: preceding 3 lines from PG_LINK1

  • 35. Re: ORACLE to POSTGRES db link not working
    kgronau Guru
    Currently Being Moderated

    as I said - that can happen for mimicked tables when the ODBC driver does not return the correct error message which forces the gateway to use the internal mechanisms (root cause analysis would require ODBC traces). So best would be in those cases to ask the Postgres admin which objects exist in the database and then to check if you can query one of them.

  • 36. Re: ORACLE to POSTGRES db link not working
    user13573211 Newbie
    Currently Being Moderated

    [oracle@scflsdb001 log]$ cat postgresql_agt_16113.trc

     

     

     

     

    Oracle Corporation --- FRIDAY    SEP 27 2013 09:01:47.541

     

     

     

     

    Heterogeneous Agent Release

    11.2.0.3.0

     

     

     

     

     

     

     

     

    Oracle Corporation --- FRIDAY    SEP 27 2013 09:01:47.541

     

     

        Version 11.2.0.3.0

     

     

    Entered hgogprd

    HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"

    Entered hgosdip

    setting HS_OPEN_CURSORS to default of 50

    setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

    setting HS_FDS_RECOVERY_PWD to default value

    setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG

    setting HS_IDLE_TIMEOUT to default of 0

    setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

    setting HS_NLS_NCHAR to default of "AL32UTF8"

    setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"

    setting HS_FDS_DATE_MAPPING to default of "DATE"

    setting HS_RPC_FETCH_REBLOCKING to default of "ON"

    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"

    setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"

    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 64 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 "postgresql"

    Product-Info:

      Port Rls/Upd:3/0 PrdStat:0

      Agent:Oracle Database Gateway for ODBC

      Facility:hsa

      Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:postgresql

    Exiting hgogprd, rc=0

    Entered hgoinit

    HOCXU_COMP_CSET=1

    HOCXU_DRV_CSET=31

    HOCXU_DRV_NCHAR=873

    HOCXU_DB_CSET=178

    HS_LANGUAGE not specified

    LANG=en_US.UTF-8

    HOCXU_SEM_VER=112000

    Entered hgolofn at 2013/09/27-09:01:47

    HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so"

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d608300

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d608390

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d608b50

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d609dc0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d611890

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d611d30

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d614580

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d615a20

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d616220

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d617c40

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d617c60

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d619370

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61c4f0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61c890

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61e330

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61ef80

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61f280

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d6210b0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d621480

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d622fc0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d622e10

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d60a3e0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d60bb80

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d60f4f0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d611150

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d612890

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d6154b0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d616b40

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d617fb0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d6199d0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d619e90

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61b060

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61bc90

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61cad0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61d4d0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61df90

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61f9b0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d61fec0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d620470

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d620b00

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d621770

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d624320

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d622b30

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d6258c0

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Entered hgolofns at 2013/09/27-09:01:47

    symbol_peflctx=0x3d626550

    hoaerr:0

    Exiting hgolofns at 2013/09/27-09:01:47

    Exiting hgolofn, rc=0 at 2013/09/27-09:01:47

    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 64 given for HS_FDS_SQLLEN_INTERPRETATION

    treat_SQLLEN_as_compiled = 1

    Exiting hgoinit, rc=0 at 2013/09/27-09:01:47

    Entered hgolgon at 2013/09/27-09:01:47

    reco:0, name:postgres, tflag:0

    Entered hgosuec at 2013/09/27-09:01:47

    Exiting hgosuec, rc=0 at 2013/09/27-09:01:47

    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 postgres as default value for "HS_FDS_DEFAULT_OWNER"

    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"

    Entered hgocont at 2013/09/27-09:01:47

    HS_FDS_CONNECT_INFO = "postgresql"

    RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"

    Entered hgogenconstr at 2013/09/27-09:01:47

    dsn:postgresql, name:postgres

    optn:

    Entered hgocip at 2013/09/27-09:01:47

    dsn:postgresql

    Exiting hgocip, rc=0 at 2013/09/27-09:01:47

    Exiting hgogenconstr, rc=0 at 2013/09/27-09:01:47

    Entered hgolosf at 2013/09/27-09:01:47

    Exiting hgolosf, rc=0 at 2013/09/27-09:01:47

    DriverName:psqlodbcw.so, DriverVer:09.02.0100

    DBMS Name:PostgreSQL, DBMS Version:PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit

    Exiting hgocont, rc=0 at 2013/09/27-09:01:47

    SQLGetInfo returns Y for SQL_CATALOG_NAME

    SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN

    Exiting hgolgon, rc=0 at 2013/09/27-09:01:47

    Entered hgoulcp at 2013/09/27-09:01:47

    Entered hgowlst at 2013/09/27-09:01:47

    Exiting hgowlst, rc=0 at 2013/09/27-09:01:47

    SQLGetInfo returns 0x1d for SQL_OWNER_USAGE

    TXN Capable:2, Isolation Option:0xa

    SQLGetInfo returns 64 for SQL_MAX_SCHEMA_NAME_LEN

    SQLGetInfo returns 64 for SQL_MAX_TABLE_NAME_LEN

    SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN

    HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER

    SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR

    2 instance capabilities will be uploaded

      capno:1989, context:0x00000000, add-info:        0

      capno:1992, context:0x0001ffff, add-info:        0

    Exiting hgoulcp, rc=0 at 2013/09/27-09:01:47

    Entered hgouldt at 2013/09/27-09:01:47

    NO instance DD translations were uploaded

    Exiting hgouldt, rc=0 at 2013/09/27-09:01:47

    Entered hgobegn at 2013/09/27-09:01:47

    tflag:0 , initial:1

    hoi:0x540d5238, ttid (len 30) is ...

      00: 4D59574C 44445632 2E636236 33323431  [MYWLDDV2.cb63241]

      10: 372E322E 32302E36 32363232 3332      [7.2.20.6262232]

                     tbid (len 27) is ...

      00: 4D59574C 44445632 5B322E32 302E3632  [MYWLDDV2[2.20.62]

      10: 36323233 325D5B31 2E345D             [62232][1.4]]

    Exiting hgobegn, rc=0 at 2013/09/27-09:01:47

    Entered hgodtab at 2013/09/27-09:01:47

    count:1

      table: shopping_list

    Allocate hoada[0] @ 0x1697a950

    Free hoada[0] @ 0x1697a950

    SQL text from hgodtab, id=0, len=29 ...

         00: 73656C65 6374202A 2066726F 6D202273  [select * from "s]

         10: 686F7070 696E675F 6C697374 22        [hopping_list"]

    Entered hgopoer at 2013/09/27-09:01:47

    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

    ERROR:  relation "shopping_list" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    Exiting hgopoer, rc=0 at 2013/09/27-09:01:47

    Entered hgopdsc at 2013/09/27-09:01:47

    Describing procedure shopping_list

    Output hoada

    hgopdsc, line 1434: NO hoada to print

    Exiting hgopdsc, rc=942 at 2013/09/27-09:01:47

    The hoada for table shopping_list follows...

    hgodtab, line 1092: NO hoada to print

    Exiting hgodtab, rc=0 at 2013/09/27-09:01:47

    Entered hgopars, cursor id 1 at 2013/09/27-09:01:47

    type:0

    SQL text from hgopars, id=1, len=29 ...

         00: 53454C45 4354202A 2046524F 4D202273  [SELECT * FROM "s]

         10: 686F7070 696E675F 6C697374 22        [hopping_list"]

    Entered hgopoer at 2013/09/27-09:01:47

    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

    ERROR:  relation "shopping_list" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    Exiting hgopoer, rc=0 at 2013/09/27-09:01:47

    hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

    Exiting hgopars, rc=28500 at 2013/09/27-09:01:47 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns

    Entered hgodtab at 2013/09/27-09:07:17

    count:1

      table: usr_acct

    Allocate hoada[0] @ 0x1697a950

    Free hoada[0] @ 0x1697a950

    SQL text from hgodtab, id=0, len=24 ...

         00: 73656C65 6374202A 2066726F 6D202275  [select * from "u]

         10: 73725F61 63637422                    [sr_acct"]

    Entered hgopoer at 2013/09/27-09:07:17

    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

    ERROR:  relation "usr_acct" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    Exiting hgopoer, rc=0 at 2013/09/27-09:07:17

    Entered hgopdsc at 2013/09/27-09:07:17

    Describing procedure usr_acct

    Output hoada

    hgopdsc, line 1434: NO hoada to print

    Exiting hgopdsc, rc=942 at 2013/09/27-09:07:17

    The hoada for table usr_acct follows...

    hgodtab, line 1092: NO hoada to print

    Exiting hgodtab, rc=0 at 2013/09/27-09:07:17

    Entered hgopars, cursor id 1 at 2013/09/27-09:07:17

    type:0

    SQL text from hgopars, id=1, len=24 ...

         00: 53454C45 4354202A 2046524F 4D202275  [SELECT * FROM "u]

         10: 73725F61 63637422                    [sr_acct"]

    Entered hgopoer at 2013/09/27-09:07:17

    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

    ERROR:  relation "usr_acct" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    Exiting hgopoer, rc=0 at 2013/09/27-09:07:17

    hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

    Exiting hgopars, rc=28500 at 2013/09/27-09:07:17 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns

    Entered hgodtab at 2013/09/27-09:07:42

    count:1

      table: Usr_acct

    Allocate hoada[0] @ 0x1697a950

    Free hoada[0] @ 0x1697a950

    SQL text from hgodtab, id=0, len=24 ...

         00: 73656C65 6374202A 2066726F 6D202255  [select * from "U]

         10: 73725F61 63637422                    [sr_acct"]

    Entered hgopoer at 2013/09/27-09:07:42

    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

    ERROR:  relation "Usr_acct" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    Exiting hgopoer, rc=0 at 2013/09/27-09:07:42

    Entered hgopdsc at 2013/09/27-09:07:42

    Describing procedure Usr_acct

    Output hoada

    hgopdsc, line 1434: NO hoada to print

    Exiting hgopdsc, rc=942 at 2013/09/27-09:07:42

    The hoada for table Usr_acct follows...

    hgodtab, line 1092: NO hoada to print

    Exiting hgodtab, rc=0 at 2013/09/27-09:07:42

    Entered hgopars, cursor id 1 at 2013/09/27-09:07:42

    type:0

    SQL text from hgopars, id=1, len=24 ...

         00: 53454C45 4354202A 2046524F 4D202255  [SELECT * FROM "U]

         10: 73725F61 63637422                    [sr_acct"]

    Entered hgopoer at 2013/09/27-09:07:42

    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

    ERROR:  relation "Usr_acct" does not exist at character 21;

    No query has been executed with that handle {HY000,NativeErr = 1}

    Exiting hgopoer, rc=0 at 2013/09/27-09:07:42

    hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

    Exiting hgopars, rc=28500 at 2013/09/27-09:07:42 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns

    Entered hgocomm at 2013/09/27-10:04:10

    keepinfo:0, tflag:1

       00: 4D59574C 44445632 2E636236 33323431  [MYWLDDV2.cb63241]

       10: 372E322E 32302E36 32363232 3332      [7.2.20.6262232]

                     tbid (len 27) is ...

       00: 4D59574C 44445632 5B322E32 302E3632  [MYWLDDV2[2.20.62]

       10: 36323233 325D5B31 2E345D             [62232][1.4]]

    cmt(0):

    Entered hgocpctx at 2013/09/27-10:04:10

    Exiting hgocpctx, rc=0 at 2013/09/27-10:04:10

    Exiting hgocomm, rc=0 at 2013/09/27-10:04:10

    Entered hgolgof at 2013/09/27-10:04:10

    tflag:1

    Exiting hgolgof, rc=0 at 2013/09/27-10:04:10

    Entered hgoexit at 2013/09/27-10:04:10

    Exiting hgoexit, rc=0

  • 37. Re: ORACLE to POSTGRES db link not working
    kgronau Guru
    Currently Being Moderated

    Please start isql, the ODBC test utility and try to select from these tables that you want to access using the gateway (shopping_list, usr_acct), does that work?

    - Klaus

  • 38. Re: ORACLE to POSTGRES db link not working
    kgronau Guru
    Currently Being Moderated

    According to your configuration the unixODBC Driver Manager library was installed into /usr/lib64 - see the location of the libodbc.so file. I assume you've used a package to install the driver manager, so check out the package details where it might have placed all other required libs/source files.

  • 39. Re: ORACLE to POSTGRES db link not working
    user13573211 Newbie
    Currently Being Moderated

    Hello MR.Kgronau:

     

    Could you PLEASE PLEASE PLEASE look into the below thread please.

     

    https://forums.oracle.com/message/11222242#11222242

  • 40. Re: ORACLE to POSTGRES db link not working
    user13573211 Newbie
    Currently Being Moderated

    Hello MR.Kgronau:

     

    Could you PLEASE look into the below thread please.

     

    https://forums.oracle.com/thread/2590577?start=0&tstart=0

1 2 3 Previous Next

Legend

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