queryDb: Smaller queries to data base

Description Usage Arguments

View source: R/queryDb.R

Description

If the query list needed is less than 1001 of length, this function can be used with a direct sql, not using an R object. Function will terminate connection upon completion of the query

Usage

1
2
3
4
queryDb(sql, user_id = Sys.getenv("ORACLE_UID"),
  password = Sys.getenv("ORACLE_PASS"),
  conString = "(DESCRIPTION_LIST= (LOAD_BALANCE=off)(FAILOVER=on) (DESCRIPTION=(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS= (PROTOCOL=TCP)(HOST=prd-scan.monsanto.com)(PORT=1521)) ) (CONNECT_DATA=(SERVICE_NAME=oltppsvc.monsanto.com)(SERVER=DEDICATED)) (RETRY_COUNT=1) (TRANSPORT_CONNECT_TIMEOUT = 3) (CONNECT_TIMEOUT=30) ) (DESCRIPTION=(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=ppri-scan.monsanto.com)(PORT=1521)) ) (CONNECT_DATA=(SERVICE_NAME=oltppsvc.monsanto.com)(SERVER=DEDICATED)) (RETRY_COUNT=1) (TRANSPORT_CONNECT_TIMEOUT = 3) (CONNECT_TIMEOUT=30) ) )",
  data = NULL)

Arguments

sql

The character string sql query in standard Oracle sql language

ORALCE_UID

Oracle data base user ID, set up as system variable

ORALCE_PASS

Oracle data base password, set up as system variable

CON_STRING

Oracle data base connections string, set up as system variable


elalemano/buzzwink documentation built on May 20, 2019, 9:59 a.m.