Click here to Skip to main content
15,881,204 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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")')

"@
}
}
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900