michael_dickens Posted September 25, 2018 Share Posted September 25, 2018 Have a jasper report using jdbc connection to an oracke database. Get below error when running report for certain months:Caused by: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512I can run the query successfully in other reporting/client tools. Is there a setting for Jasper Reports or web config files to resolve this error? Link to comment Share on other sites More sharing options...
michael_dickens Posted September 25, 2018 Author Share Posted September 25, 2018 mispelled oracle Link to comment Share on other sites More sharing options...
reportdev Posted September 25, 2018 Share Posted September 25, 2018 From working on Oracle databases, I can tell you this is not related to JasperCheck your datasource.It should be calling some PL/SQL or Update/Insert statements which are causing a buffer overflow on one/many variables in PL/SQL code on the tables. Link to comment Share on other sites More sharing options...
michael_dickens Posted September 27, 2018 Author Share Posted September 27, 2018 I would expect to get same error in sqlplus or SQLDeveloper if oracle issue. 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