<%@page import="oracle.jdbc.*"%>
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%
    OracleConnection conn = null;
    OracleCallableStatement stmt = null;
    try {
        request.setCharacterEncoding("Cp1251");
        DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
        conn = (OracleConnection) DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.9:1521:orcl", "test", "test");
        stmt = (OracleCallableStatement) conn.prepareCall(
                "Begin ? := Crm_Call_Center.Info(?, ?, ?, ?, ?, ?, ?,"
                + "  :p_Phone_Number);"
                + "End;");
        stmt.registerOutParameter(1, Types.INTEGER);  // o_Result
        stmt.registerOutParameter(2, Types.VARCHAR);  // o_Out_Text
        stmt.registerOutParameter(3, Types.VARCHAR);  // o_Org_Name  
        stmt.registerOutParameter(4, Types.VARCHAR);  // o_Subject_Code
        stmt.registerOutParameter(5, Types.VARCHAR);  // o_Name
        stmt.registerOutParameter(6, Types.VARCHAR);  // o_Phone_Number
        stmt.registerOutParameter(7, Types.VARCHAR);  // o_Subject_Type
        stmt.registerOutParameter(8, Types.VARCHAR);  // o_Contact_Name
        stmt.setStringAtName("p_Phone_Number", request.getParameter("p_Phone_Number"));
        stmt.execute();
        int res = stmt.getInt(1);
        if (res == 0) {
            out.println(stmt.getString(2));
        } else {			
            out.println(stmt.getString(5));
		}
    } catch (Exception e) {
        out.println(e.getMessage());
    } finally {
        if (stmt != null) {
            stmt.close();
            stmt = null;
        }
        conn.close();
    }
%>