Page 1 of 1
ORA-24337: statement handle not prepared
Posted: Wed 15 Jul 2009 11:48
by s_b
Hi
I am running a multi threaded application (client mode), and keep getting an oracle error ORA-24337.
Any idea anyone?
Posted: Wed 15 Jul 2009 20:25
by cfeidi
--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?
Posted: Fri 17 Jul 2009 07:32
by Plash
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.
Problem solved
Posted: Mon 20 Jul 2009 20:21
by s_b
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.
Posted: Tue 21 Jul 2009 10:49
by Challenger
The behavior with the first created session is designed.