Forums Register Login

JDBC Stored Procs and Temp tables

+Pie Number of slices to send: Send
Hi,

I am using a java program to call a stored procedure using the PreparedStatement.

The Stored Procedure uses a select statement to select a particular column and insert the values into a temp table. I do a query of temp table at the end of the stored procedure. the output of stored procedure is a CURSOR.

The output is coming fine when I run the S tored Procedure on SQL Plus. But in Java I am not getting the output. I use the SYSREFCURSOR to get the cursor in Java.

In one of the articles on net I read that PreparedStatement when used like select count(*) from temp table will not work. Is this the same case for stored procedures also?

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/67b10d74-e94f-4b58-8ee3-59ff390db1cf

Please guide me. Thanks.

Nags
+Pie Number of slices to send: Send
Welcome to JavaRanch, Nags.
+Pie Number of slices to send: Send
Hi Nags,

Welcome to JavaRanch.

Using temp table is always tricky with Java.

Temporary table in oracle is always bound to user's connection. remember the connection i am referring to is the physical connection with your oracle server, if your environment is using connection pooling then you can not be certain if you will get the results because if it is same connection which populated the temporary table then you will get result else you will not.

could you please provide us the environment details .

Shailesh
Would you like to try a free sample? Today we are featuring tiny ads:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2244 times.
Similar Threads
Problem with IE7
JDBC architecture interview question
cursor?
Get motherboard serial Number of local system.
no sqljdbc_auth in java.library.path
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 16:36:20.