private   static   void  testResultSetParameters(Connection con)
     throws  SQLException {
    OraclePreparedStatement cst =  null ;
    ResultSet rs =  null ;
     try  {
      cst = (OraclePreparedStatement) con.prepareStatement(
        "select e.*\n" +
          "from scott.emp e\n" +
          "where e.empno = :empno\n" +
          "   or e.empno = :empno"
      );
      cst.setIntAtName("empno",  7369 );
      rs = cst.executeQuery();
       while  (rs.next()) {
        System.out.println("ename=" + rs.getString("ename"));
      }
    }  finally  {
       if  (rs !=  null ) { rs.close(); }
       if  (cst !=  null ) { cst.close(); }
    }
  }

java.sql.SQLException: Incorrectly set or registered parameters.
	at oracle.jdbc.driver.OracleSql.setNamedParameters(OracleSql.java:211)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4221)

java.sql.SQLException: operation not allowed: Ordinal binding and Named binding cannot be combined!
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4219)

PreparedStatement pst = con.prepareStatement("{call foo(param=>?,param2=>?)}")