Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Link Error to MySQL when using variables

ZGibson_BZFeb 8 2013 — edited May 23 2013
Hi Guys

I currently hava a database link to MySQL. I can read, insert, delete and update with no problems when using literals. However when I attempt to carry out the same actions using pl/sql variables I recieve the following error:

ORA-02055: distributed update operation failed; rollback required
ORA-02068: following severe error from AAA1
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ProdDB.btl.net)(PORT=1527))(CONNECT_DATA=(SID=AAA1)))
ORA-06512: at line 15

Could you kindly give me some suggestions?


PL/SQL Code

Declare

MSISDN2 char(8);
IMSI2 number(28,0);
ICC2 number(28,0);
cnt number(28,0);

Begin

MSISDN2 :='610-0850';
IMSI2:=8950167090300132451;
ICC2:=702670161017765;


delete from "SUBSCRIBERS"@AAA1 where "MSISDN" = MSISDN2;--"ICC" = ICC2 or "IMSI" = IMSI2;

End;


-----------------------------------------------------------------------------------------------------------
System Info:

Oracle Database 10.2.0.5.0 on Redhat Linux 64 bit

Oracle Database Gateways for ODBC 11.2.0.1.0 on same machine as above

UnixODBC-3.2.1 compiled in 64bit mode on same machine as well

MySQL ODBC Connector DriverVer:05.02.0002

------------------------------------------------------------------------------------------------------
ODBC DSN

;
; odbc.ini configuration for Connector/ODBC and Connector/ODBC 3.51 drivers
;

[ODBC Data Sources]
AAA1 = MyODBC 5.2.2 Driver DSN

[AAA1]
Driver = /usr/lib64/libmyodbc5w.so
Description = Connector/ODBC 5.52 Driver DSN
SERVER = 10.50.18.89
USER = tytancc2
Password = xxxxxx
Database = radiator
OPTION = 3
CHARSET = latin1
Trace = yes
TraceFile = /tmp/unixodbc.sql.log
Debug = 1
Debugfile = /tmp/unixodbc.debug.log

---------------------------------------------------------------------------------------
HS File
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = AAA1
#HS_FDS_TRACE_LEVEL = 255
HS_FDS_TRACE_LEVEL = DEBUG
#HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5w.so
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so.2
HS_FDS_SQLLEN_INTERPRETATION=32
#HS_LANGUAGE = AMERICAN_AMERICA.AL32UTF8
#HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15
#HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
HS_LANGUAGE = AMERICAN_AMERICA.LATIN1
HS_FDS_FETCH_ROWS=1
#HS_NLS_NCHAR= UCS2
#HS_OPEN_CURSORS=10


#
# ODBC specific environment variables
#
set ODBCINI=/u01/oracle/.odbc.ini
set ODBCINSTINI=/etc/odbcinst.ini


#
# Environment variables required for the non-Oracle system
#
set LD_LIBRARY_PATH=/usr/lib64


--------------------------------------------------------------------------------------------
Trace File

Oracle Corporation --- FRIDAY FEB 08 2013 22:01:40.555


Heterogeneous Agent Release
11.2.0.1.0




Oracle Corporation --- FRIDAY FEB 08 2013 22:01:40.549

Version 11.2.0.1.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"
HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
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"
HOSGIP returned value of "32" 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 "AAA1"
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:AAA1
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=31
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=31
HOCXU_SEM_VER=102000
Entered hgolofn at 2013/02/08-22:01:40
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so.2"
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a08f61
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a090e5
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a09c18
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a0b6dc
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a17bc4
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a182e8
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a1bc40
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a1dad8
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a1e6dc
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a20bae
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a20bd0
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a22f44
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a276d4
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a27b90
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2a4a4
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2b574
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2b99c
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2e65c
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2ecd0
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a31db8
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a31ac0
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a0c47c
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a0e884
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a14943
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a1714a
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a19327
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a1d2ce
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a1f648
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a210c7
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a23990
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2414c
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a25d26
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a26cc0
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a288a8
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a28c67
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a29e88
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2c51e
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2ccfa
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2d5c0
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2de92
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a2f088
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a33fa4
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a315fe
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a36de2
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Entered hgolofns at 2013/02/08-22:01:40
symbol_peflctx=0x31a380ec
hoaerr:0
Exiting hgolofns at 2013/02/08-22:01:40
Exiting hgolofn, rc=0 at 2013/02/08-22:01:40
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
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 = 0
Exiting hgoinit, rc=0 at 2013/02/08-22:01:40
Entered hgolgon at 2013/02/08-22:01:40
reco:0, name:tytancc2, tflag:0
Entered hgosuec at 2013/02/08-22:01:40
Exiting hgosuec, rc=0 at 2013/02/08-22:01:40
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 tytancc2 as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
Entered hgocont at 2013/02/08-22:01:40
HS_FDS_CONNECT_INFO = "AAA1"
RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
Entered hgogenconstr at 2013/02/08-22:01:40
dsn:AAA1, name:tytancc2
optn:
Entered hgocip at 2013/02/08-22:01:40
dsn:AAA1
Exiting hgocip, rc=0 at 2013/02/08-22:01:40
Exiting hgogenconstr, rc=0 at 2013/02/08-22:01:40
Entered hgolosf at 2013/02/08-22:01:45
Exiting hgolosf, rc=0 at 2013/02/08-22:01:45
DriverName:libmyodbc5w.so, DriverVer:05.02.0002
DBMS Name:MySQL, DBMS Version:5.1.66-community-log
Exiting hgocont, rc=0 at 2013/02/08-22:01:45
SQLGetInfo returns Y for SQL_CATALOG_NAME
SQLGetInfo returns 192 for SQL_MAX_CATALOG_NAME_LEN
Exiting hgolgon, rc=0 at 2013/02/08-22:01:45
Entered hgoulcp at 2013/02/08-22:01:45
Entered hgowlst at 2013/02/08-22:01:45
Exiting hgowlst, rc=0 at 2013/02/08-22:01:45
SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
TXN Capable:3, Isolation Option:0xf
SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
SQLGetInfo returns 192 for SQL_MAX_TABLE_NAME_LEN
SQLGetInfo returns 192 for SQL_MAX_PROCEDURE_NAME_LEN
SQLGetInfo returns ` (0x60) for SQL_IDENTIFIER_QUOTE_CHAR
SQLGetInfo returns Y for SQL_COLUMN_ALIAS
16 instance capabilities will be uploaded
capno:1964, context:0x00000000, add-info: 0
capno:1989, context:0x00000000, add-info: 0
capno:1991, context:0x0001ffff, add-info: 0
capno:1992, context:0x0001ffff, add-info: 1, translation:"`"
capno:3042, context:0x00000000, add-info: 0, translation:"42"
capno:3047, context:0x00000000, add-info: 0, translation:"57"
capno:3049, context:0x00000000, add-info: 0, translation:"59"
capno:3050, context:0x00000000, add-info: 0, translation:"60"
capno:3066, context:0x00000000, add-info: 0
capno:3067, context:0x00000000, add-info: 0
capno:3068, context:0x00000000, add-info: 0
capno:3069, context:0x00000000, add-info: 0
capno:3500, context:0x00000001, add-info: 91, translation:"42"
capno:3501, context:0x00000001, add-info: 93, translation:"57"
capno:3502, context:0x00000001, add-info: 107, translation:"59"
capno:3503, context:0x00000001, add-info: 110, translation:"60"
Exiting hgoulcp, rc=0 at 2013/02/08-22:01:45
Entered hgouldt at 2013/02/08-22:01:45
NO instance DD translations were uploaded
Exiting hgouldt, rc=0 at 2013/02/08-22:01:45
Entered hgobegn at 2013/02/08-22:01:45
tflag:0 , initial:1
hoi:0x9671a48, ttid (len 26) is ...
00: 54595441 4E2E6438 32323564 62642E32 [TYTAN.d8225dbd.2]
10: 392E372E 33313031 3433 [9.7.310143]
tbid (len 10) is ...
0: 1D000700 7FBB0400 0104 [..........]
Exiting hgobegn, rc=0 at 2013/02/08-22:01:45
Entered hgopdsc at 2013/02/08-22:01:45
Describing procedure SUBSCRIBERS
Output hoada
hgopdsc, line 1406: NO hoada to print
Exiting hgopdsc, rc=942 at 2013/02/08-22:01:45
Entered hgodtab at 2013/02/08-22:01:45
count:1
table: SUBSCRIBERS
Allocate hoada[0] @ 0x3a23590
Entered hgopcda at 2013/02/08-22:01:45
Column:1(MSISDN): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:2(IMSI): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:3(ICC): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:4(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:5(REPLYATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:6(TIMELEFT): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:7(ELIMINATED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:8(SUSPENDED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:10
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
The hoada for table SUBSCRIBERS follows...
hgodtab, line 876: Printing hoada @ 0x3a23590
MAX:8, ACTUAL:8, BRC:1, WHT=6 (TABLE_DESCRIBE)
hoadaMOD bit-values found (0x200:TREAT_AS_CHAR,0x20:NEGATIVE_HOADADTY)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
1 CHAR N 8 8 0/ 0 0 0 200 MSISDN
-5 BIGINT N 8 8 0/ 0 0 0 20 IMSI
-5 BIGINT N 8 8 0/ 0 0 0 20 ICC
1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
1 CHAR Y 200 200 0/ 0 0 0 200 REPLYATTR
-5 BIGINT Y 8 8 0/ 0 0 0 20 TIMELEFT
-5 BIGINT Y 8 8 0/ 0 0 0 20 ELIMINATED
-5 BIGINT Y 8 8 0/ 0 0 0 20 SUSPENDED
Exiting hgodtab, rc=0 at 2013/02/08-22:01:45
Entered hgodafr, cursor id 0 at 2013/02/08-22:01:45
Free hoada @ 0x3a23590
Exiting hgodafr, rc=0 at 2013/02/08-22:01:45
Entered hgopars, cursor id 1 at 2013/02/08-22:01:45
type:0
SQL text from hgopars, id=1, len=134 ...
00: 53454C45 43542041 312E604D 53495344 [SELECT A1.`MSISD]
10: 4E602C41 312E6049 4D534960 2C41312E [N`,A1.`IMSI`,A1.]
20: 60494343 602C4131 2E604348 45434B41 [`ICC`,A1.`CHECKA]
30: 54545260 2C41312E 60524550 4C594154 [TTR`,A1.`REPLYAT]
40: 5452602C 41312E60 54494D45 4C454654 [TR`,A1.`TIMELEFT]
50: 602C4131 2E60454C 494D494E 41544544 [`,A1.`ELIMINATED]
60: 602C4131 2E605355 5350454E 44454460 [`,A1.`SUSPENDED`]
70: 2046524F 4D206053 55425343 52494245 [ FROM `SUBSCRIBE]
80: 52536020 4131 [RS` A1]
Exiting hgopars, rc=0 at 2013/02/08-22:01:45
Entered hgoopen, cursor id 1 at 2013/02/08-22:01:45
hgoopen, line 86: NO hoada to print
Deferred open until first fetch.
Exiting hgoopen, rc=0 at 2013/02/08-22:01:45
Entered hgodscr, cursor id 1 at 2013/02/08-22:01:45
Allocate hoada @ 0x3a23538
Entered hgopcda at 2013/02/08-22:01:45
Column:1(MSISDN): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:2(IMSI): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:3(ICC): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:0, octet:8, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:4(CHECKATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:5(REPLYATTR): dtype:1 (CHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:6(TIMELEFT): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:7(ELIMINATED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
Entered hgopcda at 2013/02/08-22:01:45
Column:8(SUSPENDED): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:200, sign:1, radix:0
Exiting hgopcda, rc=0 at 2013/02/08-22:01:45
hgodscr, line 880: Printing hoada @ 0x3a23538
MAX:8, ACTUAL:8, BRC:1, WHT=5 (SELECT_LIST)
hoadaMOD bit-values found (0x200:TREAT_AS_CHAR,0x20:NEGATIVE_HOADADTY)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
1 CHAR N 8 8 0/ 0 0 0 200 MSISDN
-5 BIGINT N 8 8 0/ 0 0 0 20 IMSI
-5 BIGINT N 8 8 0/ 0 0 0 20 ICC
1 CHAR Y 200 200 0/ 0 0 0 200 CHECKATTR
1 CHAR Y 200 200 0/ 0 0 0 200 REPLYATTR
-5 BIGINT Y 8 8 0/ 0 0 0 20 TIMELEFT
-5 BIGINT Y 8 8 0/ 0 0 0 20 ELIMINATED
-5 BIGINT Y 8 8 0/ 0 0 0 20 SUSPENDED
Exiting hgodscr, rc=0 at 2013/02/08-22:01:45
Entered hgoclse, cursor id 1 at 2013/02/08-22:01:46
Exiting hgoclse, rc=0 at 2013/02/08-22:01:46
Entered hgodafr, cursor id 1 at 2013/02/08-22:01:46
Free hoada @ 0x3a23538
Exiting hgodafr, rc=0 at 2013/02/08-22:01:46
Entered hgopars, cursor id 1 at 2013/02/08-22:01:46
type:0
SQL text from hgopars, id=1, len=56 ...
00: 44454C45 54452046 524F4D20 60535542 [DELETE FROM `SUB]
10: 53435249 42455253 60205748 45524520 [SCRIBERS` WHERE ]
20: 60535542 53435249 42455253 602E604D [`SUBSCRIBERS`.`M]
30: 53495344 4E603D3F [SISDN`=?]
Exiting hgopars, rc=0 at 2013/02/08-22:01:46
Entered hgoexec, cursor id 1 at 2013/02/08-22:01:46
octype=3 (DELETE)
hgoexec, line 108: Printing hoada @ 0x3a23538
MAX:1, ACTUAL:1, BRC:1, WHT=3 (BIND_LIST)
hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
1 CHAR N 8 0 0/ 0 31 0 200 ?
Entered hgoprbv at 2013/02/08-22:01:46
hgoprbv, line 145: Printing hoada @ 0x3a23538
MAX:1, ACTUAL:1, BRC:1, WHT=3 (BIND_LIST)
hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
1 CHAR N 8 0 0/ 0 31 0 200 ?
Exiting hgoprbv, rc=0 at 2013/02/08-22:01:46
This post has been answered by Kgronau-Oracle on Feb 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2013
Added on Feb 8 2013
#heterogeneous-connectivity, #mysql
11 comments
2,126 views