Instant Oracle Database and PowerShell How-to - Instant Oracle Database and PowerShell How-to - page 20

2. Create an Add-Employee function to set up the Add-Oracle call:

function Add-Employee(
[Parameter(Mandatory=$true)][string]$firstName,
[Parameter(Mandatory=$true)][string]$lastName,
[Parameter(Mandatory=$true)][string]$email,
[Parameter(Mandatory=$true)][DateTime]$hireDate,
[Parameter(Mandatory=$true)][string]$jobId,
[Parameter(Mandatory=$false)][string]$phoneNumber
)
{
$params = @{ 'FIRST_NAME'=$firstName; 'LAST_NAME'=$lastName;
'EMAIL'=$email; `
'HIRE_DATE'=$hireDate; 'JOB_ID'=$jobId; 'PHONE_
NUMBER'=$phoneNumber }
$sql = @"
INSERT INTO EMPLOYEES (
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
HIRE_DATE,
JOB_ID,
PHONE_NUMBER)
VALUES (
EMPLOYEES_SEQ.NEXTVAL,
:FIRST_NAME,
:LAST_NAME,
:EMAIL,
:HIRE_DATE,
:JOB_ID,
:PHONE_NUMBER
)
"@
$employeeId = Add-Oracle $script:conn $sql $params EMPLOYEE_ID
$employeeId
}

3. Call the Add* functions to insert some records:

$conn = Connect-Oracle (Get-ConnectionString)

Add-Oracle $conn "INSERT INTO JOBS (JOB_ID,JOB_TITLE) VALUES
('CFO', 'Chief Financial Officer')"