代理要先引入classes12.jar 文件

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.CallableStatement;
import java.sql.ResultSet;
import oracle.jdbc.driver.*;

public class JavaAgent extends AgentBase {
 
    public void NotesMain() {
     Connection sqlCon = null;
      try {
          Session session = getSession();
          AgentContext agentContext = session.getAgentContext();
          Database db = session.getCurrentDatabase();
          Document doc = db.createDocument();
          doc.replaceItemValue("Form", "Code");        
         
          // (Your code goes here)
          try{
           Class.forName("oracle.jdbc.driver.OracleDriver");
           DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
           String strCon ="jdbc:oracle:thin:@Server Address:Port:DBName";
           sqlCon = DriverManager.getConnection(strCon,UserName,Password);
          
           CallableStatement cs = sqlCon.prepareCall("{call get_item_list1(?,?)}");
           cs.setString(1,Par1);
           cs.registerOutParameter(2,OracleTypes.CURSOR);
           cs.executeQuery();    
          
           ResultSet rs = (ResultSet)cs.getObject(2);
                      
           String str = "";
           while(rs.next()) {
            str = str + ";" + rs.getString(1);
            System.out.println(rs.getString(1));
           }
           System.out.println(str);
          

           doc.replacedoc.replaceItemValue("Codes", rs.getString(1));
           doc.save();
           sqlCon.close();
          } catch(SQLException e1){
           e1.printStackTrace();
           sqlCon.close();
          }
         
      } catch(Exception e) {
          e.printStackTrace();
       }
   }
}