java - ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call -


i want call procedure java code delete database. below java code , exception

string procedurecall = "{call new_porting_prc.delete_album_metadata(?)}";                         callablestatement cal = conn.preparecall(procedurecall);                         cal.setstring(1, catid);                         cal.registeroutparameter(2, oracle.jdbc.oracletypes.varchar);                         cal.execute(); 

exception is:

error ["http-bio-8080"-exec-9] (content_005fdelete_jsp.java:45) - [15-05-15 14:16:01,912] -   java.sql.sqlexception: ora-06550: line 1, column 7: pls-00306: wrong number or types of arguments in call 'delete_album_metadata' ora-06550: line 1, column 7: pl/sql: statement ignored 

can suggest going wrong?

you passing 1 parameter new_porting_prc.delete_album_metadata procedure , it's expecting different number of parameters

or

you passing varchar expecting number, date etc


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -