Getting strange error when trying to call another procedure

[Peter Hammar]

Hi, all!

Im getting "callStoredProcedure2(String,String) cannot invoke callStoredProcedure2(int,int) in DataCommon" from my int svar = callStoredProcedure2. So, I guess there are a problem related to string and int. But the below call dont use string, or does it?
Im quite new to this...

  int svar = callStoredProcedure2(" { ? = call ARGUS_KOLLI_PKG.get_kolli_brytningnr(?) }",kolliId);  

  	                private int callStoredProcedure2 (int procInt, int id) {
	                    OracleCallableStatement stmt = null;
	                    int svar = 0;
	                    
	                    try {
	                        stmt = (OracleCallableStatement)((OracleConnection)dbcon.getConnection()).prepareCall(procInt);  
	                        stmt.registerOutParameter(1,OracleTypes.INTEGER);  
	                        stmt.setInt(2,id);  
	                        stmt.execute();  
	                        svar = stmt.getInt(1);  
	                    }
	                    catch (SQLException e) {  
	                                         e.printStackTrace();  
	                                         }  
	                                        finally {  
	                                               try {  
	                                                 stmt.close();  
	                                               } catch (Exception e) {}  
	                                             }  
	                                         return svar;  
	                                     }         

[Peter Hammar]

Never mind, I saw it myself

[Jan Cumps]

Peter Hammar wrote:Never mind, I saw it myself

Can you share what you saw?

[Peter Hammar]

  
int svar = callStoredProcedure2(" { ? = call ARGUS_KOLLI_PKG.get_kolli_brytningnr(?) }",kolliId); 
  

ARGUS_KOLLI_PKG.get_kolli_brytningnr is a string, not an INT and so is kolliId

Regards
Peter

[Jan Cumps]

Thank you for sharing