My Oracle Support Banner

Query Of Table With Column Of Type ANYDATA Hangs When Using TCPS and JDBC OCI (Doc ID 2452179.1)

Last updated on JANUARY 22, 2021

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Symptoms


Query hangs when using TCPS and JDBC OCI 11.2.0.4.

A simple select like select * from tbl1, where tbl1 has only a column of type ANYDATA (create table tbl1 (x sys.anydata) hangs.
The issue only happens with TCPS and JDBC OCI; not from SQL*Plus using TCPS or JDBC without SSL.



STEPS
-----------------------
The issue can be reproduced at will when the following standalone program is run:



Changes

 

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
Changes
Cause
Solution
References


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