My Oracle Support Banner

ORA-600 [ksmcat: no current call heap] Error On Remote Gateway Query (Doc ID 1385437.1)

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


When querying a remote table via Oracle Gateways an ORA-600 [ksmcat: no current call heap] error may be encountered, possibly followed by ORA-600 [qksxaDumpXml:1]  error.  The call stack for the error will resemble the following:

... ksmcat kqlnrc kglgpr kgiina kgiinp peiinspbn kkxpispbn kgmexec evapls evaopnc rpiswu2 evaopn2 qerocnClose qerocCloseReal kxsffir kxsFreeWorkArea kxsFreeExecutionHeap kksParseCursor opiosq0 kpooprx kpoal8 opiodr ...

Additionally, when trying to insert a value into a table extracted from a remote table via Heterogenous Services, such as:

insert into scott.my_tables select TABLE_NAME TAB_NAME_S,
                                   COLUMN_NAME COL_NAME_S,
                                   upper('T_' || TABLE_NAME) TAB_NAME_B,
                                   upper(COLUMN_NAME) COL_NAME_B,
                              from ALL_TAB_COLUMNS@remotedb where rownum = 1;

this errors with:

ORA-02055: distributed update operation failed; rollback required
ORA-02047: cannot join the distributed transaction in progress

Inserting directly into the table works though, as does executing the remote database SELECT query.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.