My Oracle Support Banner

"java.sql.SQLException: Invalid Name Pattern: <schema>.<USER DEF TABLE TYPE>" With JDBC And 11g DB (Doc ID 2765441.1)

Last updated on APRIL 10, 2024

Applies to:

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

Symptoms

A java program connecting to the database 11g using a proxy user reports the next error:

  java.sql.SQLException: invalid name pattern: <schema user>.<USER DEFINED TABLE TYPE>

The test program is as follows:

 

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


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