Hi,
I have a doubt on Oracle Stored Procedures and Functions. What is difference between the two and can a stored procedure return a value back. Some one at my place wrote a stored procedure that he says returns a cursor.
I wrote code in
java using Stored Procedure in spring. But it always gives me a DB Exception.
It seems it thinks the procedure takes two parameters when I don't say its a function. I see in debug it takes the SqlOutParameter also as a stored procedure parameter. When I declare it to be a function its not, its seeing only SqlParameter declarations and changing.
It takes only one parameter.
If i change it to function in my java code, it says there is no function in scope, and there is none.
Thats when I got the doubt, can stored procedures return values.
Please answer anyone.
I had another
thread with question on how to access stored procedure, but no one is answering it.
Thanks,
Kalyana CJ.