My Oracle Support Banner

OCIDescribeAny Fails with ora-4043 when Describing PUBLIC Synonym of an UDT Object. (Doc ID 1225793.1)

Last updated on OCTOBER 07, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.1.0 [Release 8.1.7 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When trying to describe a public synonym using OCIDescribeAny type fails with ORA-04043

UTest.c


Build and execute
> make -f demo_rdbms.mk build EXE=UTest OBJS=UTest.o
> UTest
Initialize and logon
Connection created
Describe object
OCI Error - ORA-04043: object <OBJECT_NAME> does not exist

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


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