drallpradeep Posted July 31, 2008 Share Posted July 31, 2008 Hi, How to call an oracle reference cursor in jasper Report. How to distinguish between normal variable and reference cursor variable. Regards,Pradeep Link to comment Share on other sites More sharing options...
huwtrimet.org Posted July 31, 2008 Share Posted July 31, 2008 I have procedure with an out parameter returning a ref cursor and fuction result set returning ref cursor in Oracle. If some one can provide syntax for both ways will be great. Link to comment Share on other sites More sharing options...
huwtrimet.org Posted August 1, 2008 Share Posted August 1, 2008 See this link, the solution is not optimal for my environment but works for now.http://www.brianburridge.com/2006/06/04/how-to-call-stored-procedures-from-jasper-reports/ Link to comment Share on other sites More sharing options...
drallpradeep Posted August 6, 2008 Author Share Posted August 6, 2008 Hi,I prespared an store procedure in Oracle 10g and execute in toad which is working fine, but when i execute on Jasperreport 2.0 likeexec clothingissue(:rec,'08/01/2008'); It is not working, please suggest how to execute the above procedure in jasper report. Regards,Pradeepdrallpradeep@gmail.com Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now