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
Post a Comment