<%! String dataSrcStr; %>
<%@ include file="checkDataSource.jsp" %>

<%@ taglib uri="http://xmlns.oracle.com/j2ee/jsp/tld/ojsp/sqltaglib.tld" prefix="sql" %>
   <HTML> 
       <HEAD> 
           <TITLE>Result Set Iteration Sample </TITLE> 
       </HEAD>
       <BODY BGCOLOR="#FFFFFF"> 
            <HR>
            <sql:dbOpen connId="con1" dataSource="<%= dataSrcStr %>"   />
            <sql:dbQuery connId="con1" output="jdbc" queryId="myquery">
               select ENAME from EMP order by ename
            </sql:dbQuery>
            <sql:dbNextRow queryId="myquery">
                <%= myquery.getString(1) %> <br>
            </sql:dbNextRow>
            <sql:dbCloseQuery queryId="myquery" />
            <sql:dbClose connId="con1" />
            <HR> 
       </BODY> 
  </HTML> 

