OBIEE - EXECUTE PHYSICAL CONNECTION POOL Statement

About

The EXECUTE PHYSICAL CONNECTION POOL Statement permit you to execute Physical SQL statement from a BI Server Client

Articles Related

Syntax

EXECUTE PHYSICAL CONNECTION POOL  Database.ConnectionPoolName
BEGIN

  create table myTable;
  
  drop table myTable;

END;

where:

• myConnectionPool is the fully qualified name of a connection pool (ie Database.ConnectionPoolName

Documentation / Reference

• Configuring Oracle BI EE Server with Oracle Active Data Guard p8