pjamack Posted July 11, 2011 Share Posted July 11, 2011 I'm getting this error when trying to preview a Report in IReports 4 java.sql.SQLException: Missing IN or OUT parameter at index:: 5 I'm calling a Stored Procedure in Oracle, passing in parameters, returning a cursor with data.The Stored Proc works and executes in Oracle. I put in dates and data and can query the data in the Temp table. So it works as a Stored Procedure within Oracle, the data is stored temporarily in a Temp table and I can display it, view it, etc. But when I'm running a Report in JasperReports and trying to Preview with the same exact data, it comes back with that Missing Parameters. Makes no sense since it's the exact same call and works on one but not the other. 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