dbListConnections-methods: List items from Oracle objects

In ROracle: OCI Based Oracle Database Interface for R

Description

These methods are straight-forward implementations of the corresponding generic functions.

Usage

## S4 method for signature 'OraDriver'
dbListConnections(drv, ...)
## S4 method for signature 'ExtDriver'
dbListConnections(drv, ...)
## S4 method for signature 'OraConnection'
dbListResults(conn, ...)

Arguments

drv	an OraDriver or ExtDriver.
conn	an OraConnection.
...	currently unused.

Details

dbListConnections

implementation return a list of all associated connections. It shows information about all associated connections.

dbListResults

implementation return a list of all associated result sets. It shows information about all associated result sets.

Value

dbListConnections	A list of all connections associated with driver.
dbListResults	A list of all result sets associated with connection.

References

For the Oracle Database documentaion see http://www.oracle.com/technetwork/indexes/documentation/index.html.

See Also

Oracle, dbGetInfo, dbColumnInfo, dbDriver, dbConnect, dbSendQuery

Examples

  ## Not run: 
    drv <- dbDriver("Oracle")
    con1 <- dbConnect(drv, "scott", "tiger")
    res1 <- dbSendQuery(con1, "select * from emp where deptno = 10")
    res2 <- dbSendQuery(con1, "select * from emp where deptno = 20")
    con2 <- dbConnect(drv, "scott", "tiger")
    res3 <- dbSendQuery(con2, "select * from dept")

    ## get all active statements
    for(con in dbListConnections(drv))
      for (res in dbListResults(con))
        print(dbGetStatement(res))
  
## End(Not run)

ROracle documentation built on Nov. 10, 2021, 5:08 p.m.