Oci: Create a database connection object using Oracle DBMS.

In ks465/r-utils: A Collection of Wrappers for Frequently Used Codes

Description

Create a database connection object using Oracle DBMS.

Usage

Oci(db_name, db_user, db_pass, db_host, db_port = 1521)

Arguments

db_name	string. Name of the database to load.
db_user	string. User identification for the DBMS.
db_pass	string. Password identifying the user.
db_host	string. Name of the server hosting the database.
db_port	integer. Port the server is listening.

Details

Connect to a database and set con_obj in the object itself.

Value

Oci, an S3 object of type Oci containing the required parameter to act as an interface to ROracle.

Note

Oci connection is specially design to connect to AUT pGrad Portal. It will not function well in other environments.

See Also

dbConnect Database

Examples

con <- Oci(db_host = 'localhost', db_name = 'test', db_user = 'root', db_pass = '123456')
con
#$db_host
#[1] "localhost"

#$db_port
#[1] "1521"

#$db_name
#[1] "test"

#$db_user
#[1] "root"

#$db_pass
#[1] "123456"

#$con_str
#[1] "(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=test)))"

#$con_obj
#User name:             root
#Connect string:        (DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=test)))
#Server version:        11.2.0.4.0
#Server type:           Oracle RDBMS
#Results processed:     0
#OCI prefetch:          FALSE
#Bulk read:             1000
#Bulk write:            1000
#Statement cache size:  0
#Open results:          0

#attr(,"class")
#[1] "Oci"

ks465/r-utils documentation built on May 23, 2019, 5:07 p.m.