Project and Portfolio Management Practitioners Forum
cancel

Can we run kRunCachemanager.sh script through PL/SQL function or procedure

Highlighted
ShravanK
Super Contributor.

Can we run kRunCachemanager.sh script through PL/SQL function or procedure

Hello all,

Can we run kRunCachemanager.sh script through PL/SQL function or procedure.

We can run this through by setting environments in PPM. But we dont have environment setups yet in our environment and standard environment "KINTANA_SERVER" is not working properly. So we thought to execute this command through PL/SQL function or procedure.

Can anyone please help me how to execute this command through PL/SQL.

 

Best Regards,

Shravan

 

1 REPLY
TorstenNeumann
Respected Contributor.

Re: Can we run kRunCachemanager.sh script through PL/SQL function or procedure

If you do not want to setup environments, you could try the following:

 

ksc_local_exec sh -c "cd bin;sh kRunCacheManager.sh A"

I know it's not PL/SQL, but it's a solution without the need of environments.