My Oracle Support Banner

JDBC Application Fails to Resolve Object <Schema_Name>.<Object_Name> Even after Application of Patch 34306996 (Doc ID 2893978.1)

Last updated on JULY 20, 2024

Applies to:

PL/SQL - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Post database upgrade from 11g to 19c, JDBC Thin driver application fails to resolve a valid object with the following error

java.sql.SQLException: Fail to construct descriptor: Unable to resolve type "<Schema_Name>.<Object_Name>"

Usage of dbms_pickler.get_type_shape() may raises error like "ORA-21700: object does not exist or is marked for delete" or "ORA-01001: invalid cursor".

The error is reported when database contains a package with the same name as the <Schema_Name> but the the package doesn't contain any sub-program or type with the name <Object_Name>. <Bug 34306996> was filed for investigating this issue where Development team initially closed the bug as 'Not a Bug' explaining this as an expected behavior. PLSQL naming resolution uses a different order(than SQL naming resolution) to resolve names in PL/SQL statements such as assignments and subprogram calls. It first searches for packages, types, tables, and views with the name <Schema_Name> in the current schema, then for objects in the schema <Schema_Name>.

Later, a fix(applicable for non-JDBC driver also) was provided for backward compatibility where the name resolution continues the search to find the object <Object_Name> under the schema <Schema_Name> after no sub-program or type with the name <Object_Name> is found inside the package with name <Schema_Name>.

However, the behavior remains same even after application of <Patch 34306996>.

Changes

The database server is upgraded to 12.1 or onwards where support for resolving package type name was introduced for JDBC. Also, the <Patch 34306996> has been applied.

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.