Java Cómo hacer 1 Execute Immediate?

[axz]

Hola alguien podría ayudarme? ... necesito ejecutar un comando

"Execute immediate" a una base de datos Oracle.

he intentado esto y truena:

Código:

Connection connection = null;
    try
    {
      InitialContext initialContext = new InitialContext();
      DataSource dataSource = null;
      dataSource = ( DataSource )initialContext.lookup( "jdbc/conPUCoreDS" );
      connection = dataSource.getConnection();
      
      PreparedStatement pStmt = connection.prepareStatement( "EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE = AMERICAN';" );
      pStmt.execute();
      pStmt.close();
...

gracias de antemano

[manpazm]

Estimado AXZ,

Debes ejecutar la sentencia ORACLE sin EXECUTE IMMEDIATE:

Connection connection = null;
try
{
InitialContext initialContext = new InitialContext();
DataSource dataSource = null;
dataSource = ( DataSource )initialContext.lookup( "jdbc/conPUCoreDS" );
connection = dataSource.getConnection();

PreparedStatement pStmt = connection.prepareStatement( " 'ALTER SESSION SET NLS_LANGUAGE = AMERICAN';" );
pStmt.execute();
pStmt.close();
...