Hi

My procedure is

create or replace package types
as
type cursorType is ref cursor;
end;
/
create or replace function sp_ListEmp(eno number) return types.cursortype
as
l_cursor types.cursorType;
begin
open l_cursor for select ename, empno from emp
where empno >= eno order by ename;
return l_cursor;
end;
/
----------------------------------------------------------------

This is my Java Code

import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
class jdbc_2 {
public static void main (String args[]) throws Exception
{
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbcracle:thin:@geo:1521:geodb" , "scott" , "tiger");
int var1 = Integer.parseInt(args[0]);
String query = "begin ? := sp_ListEmp(?); end;";
CallableStatement cstmt = conn.prepareCall(query);
cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.setInt(2,var1);
cstmt.execute();
ResultSet rset = (ResultSet)cstmt.getObject(1);
while(rset.next())
{
System.out.print(" "+rset.getString("ename"));
System.out.print(" "+rset.getInt("empno"));
System.out.print(" "+rset.getString("job")+"\n");
}
cstmt.close();
}
}


and this is giving error after displaying first row as Invalid Column name

Can anyone help me out

Amol