This discussion is archived
1 Reply Latest reply: Dec 18, 2012 11:23 AM by Stephen Karniotis RSS

Problems using unixODBC Driver for 64-bit Linux

Stephen Karniotis Newbie
Currently Being Moderated
Good morning

We are incurring a problem with the unixODBC Driver via Oracle Heterogeneous Services for connecting from a 64-bit SUSE Linux Server to a Windows PostgreSQL database (8.2). Oracle is 11.2.0.3. We are receiving an error when retrieving SMALLINT data from PostGreSQL. This should "automagically" convert to NUMBER(5) in Oracle but we are receiving a conversion error.

Here is the text of the HS Trace file. Any help in diagnosing this would be much appreciated.



Oracle Corporation --- MONDAY DEC 17 2012 17:14:36.779


Heterogeneous Agent Release
11.2.0.3.0




Oracle Corporation --- MONDAY DEC 17 2012 17:14:36.778

Version 11.2.0.3.0

Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
Entered hgosdip
HOSGIP returned value of "50" for HS_OPEN_CURSORS
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
HOSGIP returned value of "0" for HS_IDLE_TIMEOUT
setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
setting HS_NLS_NCHAR to default of "AL32UTF8"
setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
setting HS_FDS_DATE_MAPPING to default of "DATE"
setting HS_RPC_FETCH_REBLOCKING to default of "ON"
HOSGIP returned value of "100" for HS_FDS_FETCH_ROWS
setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
HOSGIP returned value of "TRUE" for HS_FDS_RSET_RETURN_ROWCOUNT
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"
HOSGIP returned value of "64" for HS_FDS_SQLLEN_INTERPRETATION
setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
setting HS_FDS_DELAYED_OPEN to default of "TRUE"
setting HS_FDS_WORKAROUNDS to default of "0"
Exiting hgosdip, rc=0
ORACLE_SID is "dev"
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:dev
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=178
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=873
HS_LANGUAGE is american_america.we8mswin1252
LANG=en_US.UTF-8
HOCXU_SEM_VER=112000
HOSGIP for "HS_FDS_REMOTE_DB_CHARSET" returned "we8mswin1252"
Entered hgolofn at 2012/12/17-17:14:36
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/psqlodbcw.so"
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9530
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f4e70
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f8110
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f4f30
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f6d20
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5610
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f98e0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5790
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5880
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9b20
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5980
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5a60
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9de0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5b20
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f7370
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5d80
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5e00
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5f10
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5fa0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451fa160
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451fa130
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f97c0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f4f60
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f52e0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5530
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f53a0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5680
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f6eb0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9ec0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9bf0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9c60
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9c90
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9d40
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5bc0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f9f60
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5cd0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f5e80
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f74f0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f77a0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f7af0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451fa020
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451fa280
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451fa0b0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f63e0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Entered hgolofns at 2012/12/17-17:14:36
symbol_peflctx=0x451f66d0
hoaerr:0
Exiting hgolofns at 2012/12/17-17:14:36
Exiting hgolofn, rc=0 at 2012/12/17-17:14:36
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"
treat_SQLLEN_as_compiled = 1
Exiting hgoinit, rc=0 at 2012/12/17-17:14:36
Entered hgolgon at 2012/12/17-17:14:36
reco:0, name:onstar, tflag:0
Entered hgosuec at 2012/12/17-17:14:36
Exiting hgosuec, rc=0 at 2012/12/17-17:14:36
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 "TRUE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
using onstar as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
Entered hgocont at 2012/12/17-17:14:36
HS_FDS_CONNECT_INFO = "PecanStreetDB"
RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
Entered hgogenconstr at 2012/12/17-17:14:36
dsn:PecanStreetDB, name:onstar
optn:
Entered hgocip at 2012/12/17-17:14:36
dsn:PecanStreetDB
Exiting hgocip, rc=0 at 2012/12/17-17:14:36
Exiting hgogenconstr, rc=0 at 2012/12/17-17:14:36
Entered hgolosf at 2012/12/17-17:14:37
Exiting hgolosf, rc=0 at 2012/12/17-17:14:37
DriverName:psqlodbcw.so, DriverVer:08.03.0200
DBMS Name:PostgreSQL, DBMS Version:PostgreSQL 8.2.15 (Greenplum Database 4.1.1.1 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
Exiting hgocont, rc=0 at 2012/12/17-17:14:37
SQLGetInfo returns Y for SQL_CATALOG_NAME
SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN
Exiting hgolgon, rc=0 at 2012/12/17-17:14:37
Entered hgoulcp at 2012/12/17-17:14:37
Entered hgowlst at 2012/12/17-17:14:37
Exiting hgowlst, rc=0 at 2012/12/17-17:14:37
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 2012/12/17-17:14:37
Entered hgouldt at 2012/12/17-17:14:37
NO instance DD translations were uploaded
Exiting hgouldt, rc=0 at 2012/12/17-17:14:37
Entered hgobegn at 2012/12/17-17:14:37
tflag:0 , initial:1
hoi:0xcca42008, ttid (len 27) is ...
00: 534D5254 47524444 2E306635 35343862 [SMRTGRDD.0f5548b]
10: 352E392E 392E3732 323038 [5.9.9.72208]
tbid (len 24) is ...
00: 534D5254 47524444 5B392E39 2E373232 [SMRTGRDD[9.9.722]
10: 30385D5B 312E345D [08][1.4]]
Exiting hgobegn, rc=0 at 2012/12/17-17:14:38
Entered hgodtab at 2012/12/17-17:14:38
count:1
table: dev.onstar_view
Allocate hoada[0] @ 0x7794d0
Entered hgopcda at 2012/12/17-17:14:38
Column:1(dataid): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:2(timestamp_localtime): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:3(use): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:4(gen): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:5(grid): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:6(air): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:7(furnace): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
Entered hgopcda at 2012/12/17-17:14:38
Column:8(car): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
The hoada for table dev.onstar_view follows...
hgodtab, line 1092: Printing hoada @ 0x7794d0
MAX:8, ACTUAL:8, BRC:1, WHT=6 (TABLE_DESCRIBE)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
5 SMALLINT Y 2 2 0/ 0 0 0 0 dataid
91 DATE Y 16 16 0/ 0 0 0 0 timestamp_localtime
3 DECIMAL Y 31 31 28/ 6 0 0 0 use
3 DECIMAL Y 31 31 28/ 6 0 0 0 gen
3 DECIMAL Y 31 31 28/ 6 0 0 0 grid
3 DECIMAL Y 31 31 28/ 6 0 0 0 air
3 DECIMAL Y 31 31 28/ 6 0 0 0 furnace
3 DECIMAL Y 31 31 28/ 6 0 0 0 car
Exiting hgodtab, rc=0 at 2012/12/17-17:14:38
Entered hgodafr, cursor id 0 at 2012/12/17-17:14:38
Free hoada @ 0x7794d0
Exiting hgodafr, rc=0 at 2012/12/17-17:14:38
Entered hgopars, cursor id 1 at 2012/12/17-17:14:38
type:0
SQL text from hgopars, id=1, len=40 ...
00: 53454C45 43542022 64617461 69642220 [SELECT "dataid" ]
10: 46524F4D 20226465 76222E22 6F6E7374 [FROM "dev"."onst]
20: 61725F76 69657722 [ar_view"]
Exiting hgopars, rc=0 at 2012/12/17-17:14:40
Entered hgoopen, cursor id 1 at 2012/12/17-17:14:40
hgoopen, line 87: NO hoada to print
Deferred open until first fetch.
Exiting hgoopen, rc=0 at 2012/12/17-17:14:40
Entered hgodscr, cursor id 1 at 2012/12/17-17:14:40
Allocate hoada @ 0x779478
Entered hgodscr_process_sellist_description at 2012/12/17-17:14:40
Entered hgopcda at 2012/12/17-17:14:40
Column:1(dataid): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:0, sign:1, radix:0
Exiting hgopcda, rc=0 at 2012/12/17-17:14:40
hgodscr, line 464: Printing hoada @ 0x779478
MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
5 SMALLINT Y 2 2 0/ 0 0 0 0 dataid
Exiting hgodscr, rc=0 at 2012/12/17-17:14:40
Entered hgoftch, cursor id 1 at 2012/12/17-17:14:40
hgoftch, line 133: Printing hoada @ 0x779478
MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
5 SMALLINT Y 2 2 0/ 0 0 0 0 dataid
Performing delayed open.
SQLBindCol: column 1, cdatatype: -15, bflsz: 2
SQLFetch: row: 1, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 1, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 2, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 2, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 3, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 3, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 4, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 4, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 5, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 5, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 6, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 6, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 7, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 7, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 8, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 8, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 9, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 9, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 10, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 10, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 11, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 11, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 12, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 12, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 13, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 13, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 14, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 14, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 15, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 15, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 16, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 16, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 17, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 17, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 18, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 18, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 19, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 19, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 20, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 20, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 21, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 21, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 22, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 22, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 23, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 23, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 24, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 24, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 25, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 25, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 26, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 26, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 27, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 27, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 28, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 28, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 29, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 29, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 30, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 30, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 31, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 31, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 32, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 32, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 33, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 33, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 34, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 34, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 35, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 35, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 36, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 36, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 37, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 37, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 38, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 38, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 39, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 39, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 40, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 40, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 41, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 41, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 42, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 42, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 43, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 43, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 44, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 44, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 45, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 45, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 46, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 46, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 47, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 47, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 48, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 48, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 49, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 49, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 50, column 1, bflsz: 2, bflar: 2
SQLFetch: row: 50, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
SQLFetch: row: 51, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 51, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 52, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 52, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 53, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 53, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 54, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 54, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 55, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 55, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 56, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 56, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 57, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 57, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 58, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 58, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 59, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 59, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 60, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 60, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 61, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 61, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 62, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 62, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 63, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 63, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 64, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 64, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 65, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 65, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 66, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 66, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 67, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 67, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 68, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 68, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 69, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 69, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 70, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 70, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 71, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 71, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 72, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 72, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 73, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 73, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 74, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 74, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 75, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 75, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 76, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 76, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 77, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 77, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 78, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 78, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 79, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 79, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 80, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 80, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 81, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 81, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 82, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 82, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 83, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 83, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 84, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 84, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 85, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 85, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 86, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 86, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 87, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 87, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 88, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 88, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 89, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 89, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 90, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 90, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 91, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 91, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 92, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 92, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 93, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 93, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 94, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 94, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 95, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 95, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 96, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 96, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 97, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 97, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 98, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 98, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 99, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 99, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
SQLFetch: row: 100, column 1, bflsz: 2, bflar: 0
SQLFetch: row: 100, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
100 rows fetched
Exiting hgoftch, rc=0 at 2012/12/17-17:14:40
HS Agent received unexpected RPC disconnect
Network error 1003: NCR-01003: NCRS: Read error.
Entered hgoroll at 2012/12/17-17:15:36
tflag:0 , cmt(38):Unexpected EOF from Oracle - Rollback
hoi:0x756988, ttid (len 27) is ...
00: 534D5254 47524444 2E306635 35343862 [SMRTGRDD.0f5548b]
10: 352E392E 392E3732 323038 [5.9.9.72208]
tbid (len 24) is ...
00: 534D5254 47524444 5B392E39 2E373232 [SMRTGRDD[9.9.722]
10: 30385D5B 312E345D [08][1.4]]
Entered hgocpctx at 2012/12/17-17:15:36
Exiting hgocpctx, rc=0 at 2012/12/17-17:15:36
Exiting hgoroll, rc=0 at 2012/12/17-17:15:36
Entered hgodafr, cursor id 1 at 2012/12/17-17:15:36
Free hoada @ 0x779478
Exiting hgodafr, rc=0 at 2012/12/17-17:15:36
Entered hgolgof at 2012/12/17-17:15:36
tflag:0
Exiting hgolgof, rc=0 at 2012/12/17-17:15:36
Entered hgoexit at 2012/12/17-17:15:36
Exiting hgoexit, rc=0

Legend

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