Lets see your sql statement.
Dave
-----Original Message-----
From: Andrea [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 10:17 AM
To: [EMAIL PROTECTED]
Subject: servlet and oracle procedures

Hi all
 
I'm new to servlet and I have a problem
 
I call a oracle procedure from a servlet in this way
 
    CallableStatement cstmt;
    cstmt=DB.connection.prepareCall(sql);
    cstmt.setString(1, PROFILO);
    cstmt.setString(2, DESCR);
    cstmt.setInt(3, codtask);
    cstmt.setInt(4,  Integer.parseInt(COD_PROGETTO) );
 
    int risultato=cstmt.executeUpdate();
 
    the procedure starts and ends but tooks a lot of time and i take a websever timeout
  
   can i do nothing to avoid this situation?
 
    Can I call a procedure an regain control whitout waiting for the procedure response ?
 
Thanks  
Andrea

Reply via email to