ORA-24337: statement handle not prepared

s_b · Post by **s_b** » Wed 15 Jul 2009 11:48

Hi

I am running a multi threaded application (client mode), and keep getting an oracle error ORA-24337.

Any idea anyone?

cfeidi · Post by **cfeidi** » Wed 15 Jul 2009 20:25

--completion from the previous post--

It's an application that processes requests (TCP/IP). For every requests creates a thread that acquire a connection (TOraSession component).

ThreadSafety is set to true, but still we get ORA-24337: statement handle not prepared after a few (approx 5-6) connections are created

ThreadSafety should guarantee OCI (client mode) calls thread safe, right?

Any ideas, please?

Plash · Post by **Plash** » Fri 17 Jul 2009 07:32

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

s_b · Post by **s_b** » Mon 20 Jul 2009 20:21

it seems that all queries which are not connected to a session are using the first session that was opened, and we freed that session by mistake.

We added a dummy session that will be the first session in the program, and is not freed while program is running.

Challenger · Post by **Challenger** » Tue 21 Jul 2009 10:49

The behavior with the first created session is designed.

Devart Forums

ORA-24337: statement handle not prepared

ORA-24337: statement handle not prepared

Problem solved