"java.sql.SQLException: statement handle not executed: getMetaData" While Describing A Prepared Statement (Doc ID 1383811.1)

Last updated on AUGUST 01, 2023

Applies to:

Symptoms

On : 11.1.0.6 version, Thin JDBC driver

The ORACLE JDBC driver will not describe a prepared statement, instead it will throw an exception statement handle not executed: getMetaData.
There does not appear to be any documentation stating that this is considered design intent by ORACLE.
The JDBC specification would suggest that the ORACLE JDBC driver is not behaving in a standard manner.

http://download.oracle.com/javase/6/docs/api/java/sql/PreparedStatement.html#getMetaData() .

You should be able to see this with a basic program which has the sequence

Changes

Cause

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