jkeri Posted August 15, 2018 Share Posted August 15, 2018 I keep getting this error Caused by: java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'V' what i dont understand is what is 'V' ? and what causes this type of error Link to comment Share on other sites More sharing options...
riodavid Posted August 16, 2018 Share Posted August 16, 2018 "V" is the name of your stored procedure, or other Oracle sub programs. Have you created something like that?And the message tells you the arguments passed to "V" is not correct. Check your stored procedure. Link to comment Share on other sites More sharing options...
jkeri Posted August 16, 2018 Author Share Posted August 16, 2018 I dont call any store procedure in the SQL script but it does conatin several sub queries. Link to comment Share on other sites More sharing options...
jkeri Posted August 16, 2018 Author Share Posted August 16, 2018 We found the cause of this problem.In our SQL script , in the WHERE statement we had a table that was comented out, but further down in the query we referenced a column from that same table. The column was not commented.Once we commented out the column , the SQL worked. 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