I am trying to import csv data to oracle table with ParametersSo far I have done following but I need something batter if it is out there:
My solution:
'{0,-59}{1,20}' -f "Create work table WRK_UCMU074_SU_EDIT_DETAIL",(Get-Date -Format yyyyMMdd:hhmmss);
Invoke-SqlPlus -MessageOnFail 'Create work table WRK_UCMU074_SU_EDIT_DETAIL failed' -Query @"
SET PAGES 60;
SET LINES 170;
SET ECHO ON;
SET serveroutput on;
WHENEVER sqlerror exit sql.sqlcode;
EXEC drop_work_table('WRK_UCMU074_SU_EDIT_DETAIL');
create table WRK_UCMU074_SU_EDIT_DETAIL as
select IMAGE_RECNBR,CODE_BEGIN,CODE_END from SU_EDIT_DETAIL where 1 = 0;
grant select on amiuser1.WRK_UCMU074_SU_EDIT_DETAIL to misdev;
commit;
"@
"*******************************************************************************"
'{0,-60}{1,20}' -f "Insert TEEN PREGNANCY ICD10 CODES into the WRK_UCMU074_SU_EDIT_DETAIL",(Get-Date -Format yyyyMMdd:hhmmss);
foreach ($file in dir "$($UCMCSVLoadLocation3)" -recurse -filter "*.csv")
{
$fileContents = Import-Csv -Path $file.fullName
foreach ($line in $fileContents)
{
$null = Execute-NonQuery-Oracle -sql @"
insert into WRK_UCMU074_SU_EDIT_DETAIL(IMAGE_RECNBR,CODE_BEGIN,CODE_END)
Values
(0,'$($line."CODE_BEGIN")','$($line."CODE_END")')
"@
}
}