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屋！