E-PC/AE: Exec() PeopleCode Fails In App Engine But Not In Page Event When Calling SQL Server sqlcmd.exe (Doc ID 2703491.1)

Last updated on JUNE 15, 2022

Applies to:

Symptoms

On : 8.56.17 version, Application Engine

In an App Engine program, user try to invoke an external batch program via exec(), for example 

Exec("""C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\sqlcmd.exe"" -U sa -P xxxx -S ""myserver\SQL2017"" -d mydb -o c:\temp\out.txt -Q ""update PS_CURRENCY_CD_TBL set DESCR='test03' where CURRENCY_CD='CAD'""", %Exec_Synchronous + %FilePath_Absolute);

it run and did not update data. But when above code invoked from page event, it work fine with data updated.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.