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