Thread: unable to view the result generated by stored procedure

Hi
i have executing a stored procedure in which i have to give one input variable and the result will be a table view
here is my stored procedure
create proc getValues
(
@name varchar(50))
as
begin
select PID,quantity,unitprice from productentry where product=@name
end

and the result is a view
PID quantity unitprice
1002 50 0.50

how can i store each column with a variable and here is my javacode

import java.io.*;
import java.sql.*;
import java.util.*;
public class sql 
{
 public static void main(String args[])throws IOException,SQLException
{  
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
System.out.println("Enter the Product name");
String name=br.readLine(); 
int pid;
int q;
Float price;
Connection con=null;
CallableStatement proc=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:test","sa","haja");
proc=con.prepareCall("{call getValues(?)}");
proc.setString(1,name);
proc.execute();
pid=proc.getInt(1);
q=proc.getInt(3);
price=proc.getFloat(4);
System.out.println(pid);
System.out.println(q);
System.out.println(price);
}
catch(ClassNotFoundException e)
        {
            System.out.println("couldnot load database driver"+e.getMessage());
        }
        catch(SQLException e)
        {
            System.out.println("sql exception caught"+e.getMessage());
        }
}
}

whats wrong with my code

help me