/*
(C) Copyright 2000 CE Elixir Technology Pte Ltd
*/


/*<Imports>*/
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import java.util.*;
import oracle.jdbc.driver.*;
/*</Imports>*/

/**
 * Description goes here
 *
 * @author
 */

public class OracleDataSource
{
	public static void main(String[] args)
	{
		try
		{
			InitialContext ctxt;
		    Properties p = new Properties();
		    p.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
		    p.put(Context.PROVIDER_URL,"t3://127.0.0.1:7001/");
		    ctxt = new InitialContext(p);

		    DataSource ds = (DataSource)ctxt.lookup("OracleDataSource");
		    Connection con = ds.getConnection();

			

			// Prepare the PL/SQL call
			CallableStatement call=con.prepareCall("{ ? = call java_refcursor.refTypeFunc(?)}");
			
			// Find out all the SALES Person
			System.out.println("Before Registered out param");
			call.registerOutParameter(1, java.sql.Types.VARCHAR);
			//call.registerOutParameter(1, java.sql.Types.OTHER);
			System.out.println("after registerOutParam");
			
			call.setObject(2,"SALESMAN");
			call.execute();
			ResultSet rset = (ResultSet)call.getObject(1);
			
			// Dump the cursor
			while (rset.next())
				System.out.println(rset.getString("empno"));
				System.out.println(rset.getString("ENAME"));

			//close all the resources
			rset.close();
			call.close();
			con.close();
		}catch (Exception e)
		{
	  		System.out.println("Exception "+e);
	    	e.printStackTrace();
		}

	}
	
}