orch.disconnect

Disconnects the local R session from Oracle Database.

Usage

orch.disconnect(
        silent,
        dbcon)

Arguments

silent

Set to TRUE to suppress all messages, or FALSE to see them (default).

dbcon

Set to TRUE to display the connection details, or FALSE to suppress this information (default).

Usage Notes

No orch functions work without a connection to Oracle Database.

Return Value

An Oracle Database connection object when dbcon is TRUE, otherwise NULL

See Also

orch.connect

Example

This example disconnects the local R session from Oracle Database:

R> orch.disconnect()
Disconnected from a database.

The next example disconnects the local R session from Oracle Database and displays the returned connection object:

R> oid<-orch.disconnect(silent=TRUE, dbcon=TRUE)
R> oid
Object of class "orch.dbcon"
data frame with 0 columns and 0 rows
slow "ok":
[1] TRUE

Slot "host":
[1] "localhost"

Slow "port":
[1] 1521

Slot "sid":
[1] orcl

Slot "user":
[1] RQUSER

Slot "passwd":
[1] ""

Slot "secure":
[1] TRUE

Slot "drv":
[1] "sqoop"