/**
* Returns the NLS_NChar_Characterset of the oracle database. Used for NCHAR, NVARCHAR2 and NCLOB.
*
* @param stmtExecuter <code>StatementExecuter</code> instance to perform the action</code>.
* @return String declaring the used characterset
* @exception SQLException Description of the Exception
*/
private String getNLS_NChar_Characterset(StatementExecuter stmtExecuter) throws SQLException {
// see
// http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76966/ch2.htm#97247
try {
return stmtExecuter.getSingleRowColAsString(
"select VALUE from V$NLS_PARAMETERS where PARAMETER='NLS_NCHAR_CHARACTERSET'");
} catch (SQLException e) {
throw e;
} catch (Exception e) {
throw new DatabaseException(e);
}
}
