OBIEE - EXECUTE PHYSICAL CONNECTION POOL Statement

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

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

3 - 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
Advertising

4 - Documentation / Reference