{
try
{
PreparedStatement stat = _session.getSQLConnection().prepareStatement(sql);
SessionInternalFrame sessMainFrm = _session.getSessionInternalFrame();
IDatabaseObjectInfo[] dbObjs = sessMainFrm.getObjectTreeAPI().getSelectedDatabaseObjects();
StringBuffer script = new StringBuffer();
for (int i = 0; i < dbObjs.length; i++)
{
ITableInfo ti = (ITableInfo) dbObjs[i];
stat.setString(1, ti.getSimpleName());
if (s_log.isDebugEnabled()) {
s_log.debug("Running SQL: "+sql);
s_log.debug("Bind var value is: "+ti.getSimpleName());
}
ResultSet res = stat.executeQuery();
while(res.next())
{
script.append(res.getString("text"));
}
script.append(getStatementSeparator());
res.close();
//
///////////////////////////////////////////////////////////
}
stat.close();
sessMainFrm.getSQLPanelAPI().appendSQLScript(script.toString());
sessMainFrm.getSessionPanel().selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB);
}
catch (Exception e)
{
s_log.error(
"Unexpected exception while attempting to get source for view: "+