import java.sql.*;
import oracle.sqlj.runtime.Oracle;
public class SingleRowQuery extends Base {
   public static void main {
      try {
         connect;
         singleRowQuery;
      } catch  {
         e.printStackTrace;
      }
   }
   public static void singleRowQuery throws SQLException {
      String fullname = null;
      String street = null;
      #sql {
         SELECT fullname,
            street INTO :OUT fullname,
            :OUT street FROM customer WHERE ID = :IN id};
      System.out.println;
      System.out.println;
      System.out.println;
   }
}