JDBC problem

From: sujee <sujee81_at_gmail.com>
Date: 27 Jun 2005 06:14:11 -0700
Message-ID: <1119878051.215750.267720@g44g2000cwa.googlegroups.com>

1.I have created a plsql function which return an single row of a table. when i register the output paramenter in the jdbc callable statment, what is the JDBC OracleTypes mapping class for that return type;

My function is

function test_func(param 1 number)
return test_table%ROWTYPE;

i called like this
CallableStatment cs=con.prepareCall("begin ?:=test_func(?);end;");

cs.registerOutParameter(1,??????????????????????); //give me the

solution
cs.setInt(2,20);
cs.executeQuery();
???????????=cs.get???????????????(1) //give me the solution

2. what is the table contains oracle_home path and other details

3.To get the registered servers from 'tnsnames.ora' file in a oracle client, do i need a file processing(such as reading and find the entries) or is there any easy way to get it? Received on Mon Jun 27 2005 - 08:14:11 CDT