ORA-28513: internal error in heterogeneous remote agent When Numeric Value is Returned From select count command
(Doc ID 2642717.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Installed Oracle Database 12.2.0.1 and Oracle Database Gateway for ODBC 12.2.0.1 accessing Attunity database using Attunity ODBC driver
The queries returning NUMBER are failing with ORA-28513, for example:
Name Null? Type
-------------------------------- -------- -------------------------------------------------
COl1 NOT NULL CHAR(2)
COl2 NOT NULL CHAR(30)
COl3 NOT NULL CHAR(3)
COl4 NOT NULL CHAR(10)
COl5 NOT NULL CHAR(6)
COl6 NOT NULL CHAR(8)
COl7 NOT NULL CHAR(30)
SQL> select * from <table>@dblink where rownum < 2; <-- works as expected
-- ------------------------------ --- ---------- ------ -------- ------------------------------
XX SXXXXXY XXX XXX324 XXXXX363 XXXXX
SQL> select count(*) from <table>@dblink; <-- numeric value is returned for the count
select count(*) from <table>@dblink
*
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from DBLINK
The gateway trace file shows the difference.
121:
Entered hgodscr, cursor id 1 at 2019/03/05-14:18:33
Allocate hoada @ 0x1b81f00
Entered hgodscr_process_sellist_description at 2019/03/05-14:18:33
Entered hgopcda at 2019/03/05-14:18:33
Column:1($$CALC_1): dtype:2 (NUMERIC), prc/scl:19/0, nullbl:1, octet:0, sign:1, radix:0
Exiting hgopcda, rc=0 at 2019/03/05-14:18:33
hgodscr, line 470: Printing hoada @ 0x1b81f00
MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
3 DECIMAL Y 21 21 19/ 0 0 0 0 $$CALC_1
Exiting hgodscr, rc=0 at 2019/03/05-14:18:33
122:
Entered hgodscr, cursor id 1 at 2019/03/05-14:14:35
Allocate hoada @ 0x1fd2520
Entered hgodscr_process_sellist_description at 2019/03/05-14:14:35
Entered hgopcda at 2019/03/05-14:14:35
Column:1($$CALC_1): dtype:2 (NUMERIC), prc/scl:19/0, nullbl:1, octet:0, sign:1, radix:0
Exiting hgopcda, rc=0 at 2019/03/05-14:14:35
hgodscr, line 493: Printing hoada @ 0x1fd2520
MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
2 NUMERIC Y 21 21 19/ 0 0 0 0 $$CALC_1
Exiting hgodscr, rc=0 at 2019/03/05-14:14:35
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |