Fetch java.sql.resultSet into PL Sql function return as sys_refcursor
Hi All ,
I have created java program which connect using JDBC to remote database and return as resultSet to Oracle PL\ Sql function . Does it posible in java and PL Sql to fetch resultSet object in SYS_REFCURSOR? any other method to do same functionality?
Java Program
----------------
cat sqlExecution.java
import java.sql.*;
import oracle.jdbc.*;
import java.util.Properties;
import oracle.jdbc.pool.OracleDataSource;
public class sqlExecution {
String dbServiceName;
String mySql;
ResultSet rset=null;
public ResultSet checkUserExists(String dbServiceName, String mySql)
{
this.dbServiceName=dbServiceName;
this.mySql=mySql;
try
{
DBRemoteConn dbRemoteConn = new DBRemoteConn();
Connection dbConn = dbRemoteConn.makeConnection(dbServiceName);
Statement stmt = dbConn.createStatement();