CREATE OR REPLACE PROCEDURE update_log_proc (plids in Varchar2,pparas in Nclob,msg in NCLOB) asbeginupdate G3_log_info SET Paras=pparas,xml_data=msg WHERE lids=Plids; END; Database execution: Execute Update_log_proc (' 00000 ', ' Clerk ', ' msg ') Java code calls:/*** Call stored Procedure Update log data *@paramLids PRIMARY KEY *@parampara Interface parameters *@parammsg return information*/ Public Static voidcallpprocedure (String lids,string para,string msg) {Connection Connection=NULL; CallableStatement CS=NULL; Try{Connection=gsutil.getconnection (); CS= Connection.preparecall ("Call Update_log_proc (?,?,?)"); Cs.setstring (1, lids); Cs.setstring (2, para); Cs.setstring (3, MSG); Cs.execute (); } Catch(SQLException e) {e.printstacktrace (); } finally { Try { if(cs! =NULL) {cs.close (); } if(Connection! =NULL) {connection.close (); } } Catch(SQLException e) {e.printstacktrace (); } } }
Oracle with parameter stored procedure update