PowerShell脚本出现ORA-12899错误 [英] ORA-12899 error with powershell script
问题描述
我有代码mentioed beloow导致错误名称ORA-12899任何人都可以提供帮助
$ includePath = $(Split-Path -Path $ MyInvocation.MyCommand.Path -Parent | Split-Path -Parent)\ include
。 $ includePath\utils.ps1;
$ AmisysConnectionStringName;
Run-Job -JobName'ucmu073'{
$ filePath =C:\ jobs \AA \DEV6 \UCM \ ICD10.csv
$ importFile = Import-CSV $ filePath
foreach($ item in $ importFile)
{
$ proc1 = $ item.DIAG_NBR
$ proc2 = $ item.DIAG_NBR
#$ ymdeff = $ item.YMDEFF
#$ ymdend = $ item.YMDEND
#$ ymdtrans = $ item.YMDTRANS
写详细$ proc1,$ proc2
$ currentDate = Get-日期-Format yyyyMMdd
#********************* ************************************************** ********
#*在su_edit_detail中插入代码和费用。
#*************** ************************************************** **************
'{0,-60} {1,20}'-f插入TEEN PREGNANCY ICD10码S进入su_edit_detail,(Get-Date -Format yyyyMMdd:hhmmss);
$ myQuery = @
SET PAGES 600;
SET LINES 4000;
SET ECHO ON;
SET serveroutput on;
WHENEVER sqlerror退出sql.sqlcode;
插入SU_EDIT_DETAIL(EDIT_FUNCTION,TABLE_FUNCTION,CODE_FUNCTION,CODE_TYPE,CODE_BEGIN,CODE_END,EXCLUDE,INCLUDE_X,OP_NBR,TRANSCODE,VOID ,YMDEFF,YMDEND,YMDTRANS)
选择'UCM-REPT-TEEN-PREG-DIAG','UCM-REPT','I0','DIAG','$ proc1','$ proc2 ','','','MIS','C','',20141001,99991231,20131120
from dual where not exists(select * from SU_EDIT_DETAIL where(CODE_BEGIN ='$ proc1')和CODE_END ='$ proc2'));
commit;
@
$ null = Invoke-SqlPlus -MessageOnFail'插入su_edit_detail失败'-Query $ myQuery;
I have code mentioed beloow causing error name ORA-12899 anyone can help
$includePath = "$(Split-Path -Path $MyInvocation.MyCommand.Path -Parent | Split-Path -Parent)\include"
. $includePath\utils.ps1;
$AmisysConnectionStringName;
Run-Job -JobName 'ucmu073' {
$filePath = "C:\jobs\AA\DEV6\UCM\ICD10.csv"
$importFile = Import-CSV $filePath
foreach($item in $importFile)
{
$proc1 = $item.DIAG_NBR
$proc2 = $item.DIAG_NBR
# $ymdeff = $item.YMDEFF
#$ymdend = $item.YMDEND
#$ymdtrans = $item.YMDTRANS
Write-Verbose "$proc1, $proc2"
$currentDate = Get-Date -Format yyyyMMdd
# *******************************************************************************
# * Insert codes and fees into the su_edit_detail.
# *******************************************************************************
'{0,-60}{1,20}' -f "Insert TEEN PREGNANCY ICD10 CODES into the su_edit_detail ",(Get-Date -Format yyyyMMdd:hhmmss);
$myQuery = @"
SET PAGES 600;
SET LINES 4000;
SET ECHO ON;
SET serveroutput on;
WHENEVER sqlerror exit sql.sqlcode;
insert into SU_EDIT_DETAIL(EDIT_FUNCTION, TABLE_FUNCTION, CODE_FUNCTION, CODE_TYPE,CODE_BEGIN, CODE_END, EXCLUDE, INCLUDE_X, OP_NBR, TRANSCODE, VOID, YMDEFF, YMDEND, YMDTRANS)
select 'UCM-REPT-TEEN-PREG-DIAG','UCM-REPT','I0','DIAG','$proc1','$proc2',' ',' ','MIS', 'C',' ',20141001, 99991231, 20131120
from dual where not exists(select * from SU_EDIT_DETAIL where (CODE_BEGIN='$proc1' and CODE_END='$proc2'));
commit;
"@
$null = Invoke-SqlPlus -MessageOnFail 'Insert into su_edit_detail failed' -Query $myQuery;
推荐答案
includePath =
includePath = "
(Split-Path -Path
(Split-Path -Path
MyInvocation.MyCommand.Path -Parent | Split-Path -Parent)\\ \\ include
。
MyInvocation.MyCommand.Path -Parent | Split-Path -Parent)\include"
.
这篇关于PowerShell脚本出现ORA-12899错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!