gente, eu estou com problemas para usar o CallableStatement esta dando NullPointerException!!!
de uma olhada no codigo
import java.sql.*;
public class ExecutarProc{
Connection con;
String sql, contador;
CallableStatement query;
public ExecutarProc(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@xxxxxxxx:xxxx:xxxxxx","xxxxxx,"xx");
CallableStatement query = con.prepareCall("execute marcelo_contador");
carregar();
}catch(ClassNotFoundException cnfe){
cnfe.printStackTrace();
} catch(SQLException sqle){
sqle.printStackTrace();
} catch(Exception e){
e.printStackTrace();
}//catch
}
public void carregar(){
try{
query.execute();
}catch(SQLException sqle){
sqle.printStackTrace();
System.out.println(sqle);
}
}
public static void main(String[] args){
ExecutarProc f = new ExecutarProc();
}
}
e agora o erro
C:marcelo>c:jdk1.3.1_04injava -classpath “c:marceloclasses12.jar;” Execut
arProc
java.lang.NullPointerException
at ExecutarProc.carregar(ExecutarProc.java:37)
at ExecutarProc.<init>(ExecutarProc.java:19)
at ExecutarProc.main(ExecutarProc.java:56)
obrigado pela Atencao
Marcelo