Yes, i am trying to return values from pl/sql to java using ref cursor. I am getting those values and am displaying that in my java output also.
You can see that i am using "dbms_output.put_line" in this procedure. While i execute this procedure in oracle console, I am getting the ouput as just "Names: ". The usernames that were suppose to display in a loop are not displaying beside "Names:".
My question is am i using the "dbms_output.put_line" statement in a right place as in the below procedure or do i need to put all the retrieved values from a loop to some storage like cursor and then use dbms_output.put_line to display values
Joined: Sep 01, 2005
From java perspective dbms_output.put_line has no practical use. You should handle by getting resultset which is your out parameter and then iterate over the resulset and display or whatever you want.
From oracle perspective I have not seen such a usage till now. Does it really display all values from cursor? If I were you I would use a for loop for displaying results of cursor in sqlplus/toad/sql developer/etc. but again it has no benefit for java code.
But I guess your code is already working fine, or does not?
subject: Execution of stored procedure using for loop