I have a class wuth run() method that calls stored proc:
public void run()
{
Connection connection = new Connection();
Statement stmt = connection.createStatement();
SqlSystem sqlSystem = new SqlSystem();
str sqlStmt;
int i;
ResultSet resultSet;
SqlStatementExecutePermission sqlStatementExecutePermission;
;
sqlStmt = ( “exec GetAccountNumber”);
sqlStatementExecutePermission = new SqlStatementExecutePermission(sqlStmt);
sqlStatementExecutePermission.assert();
resultSet = stmt.executeQuery(sqlStmt);
while (resultSet.next())
{
info(resultSet.getString(2));
}
CodeAccessPermission::revertAssert();
}
How I can use it as a datasource in my report?
Please advise.
Thanks in advance