Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to run a program from PL/SQL?

HonestSeekerMar 12 2015 — edited Mar 23 2015

I have given the following gants for permission and calling CMD.EXE appears to work. However, I cannot get any output from whoami.exe. I can see that the default directory is C:\app\oramgr\product\12.1.0\dbhome_1\database\ that appears in the JJJ.TXT file. However, the JJJ_WHOAMI.TXT file contains nothing. Any suggestions?

dbms_java.grant_permission('PWATSON', 'SYS:java.io.FilePermission', 'C:\WINDOWS\SYSTEM32\CMD.EXE', 'execute');

dbms_java.grant_permission('PWATSON', 'SYS:java.io.FilePermission', 'C:\Windows\System32\whoami.exe', 'execute');

dbms_java.grant_permission('PWATSON', 'SYS:java.lang.RuntimePermission', '*', 'writeFileDescriptor');

dbms_java.grant_permission('PWATSON', 'SYS:java.lang.RuntimePermission', '*', 'readFileDescriptor');

dbms_java.grant_permission('PWATSON', 'SYS:java.io.FilePermission', 'C:\Users\pwatson', 'read, write');

dbms_java.grant_permission('PWATSON', 'SYS:java.io.FilePermission', 'C:\Users\pwatson\*', 'read, write');

dbms_java.grant_permission('PWATSON', 'SYS:java.io.FilePermission', 'C:\temp', 'read');

SQL> select util.RUN_CMD('C:\WINDOWS\system32\cmd.EXE /c CD C:\Users\pwatson\src\java ^& ECHO ^%CD^% ^& EXIT 4') as y from dual;

         Y

----------

         4

C:\app\oramgr\product\12.1.0\dbhome_1\DATABASE

SQL> select util.RUN_CMD('C:\WINDOWS\system32\cmd.EXE /c ECHO ^%CD^% >jjj.txt ^& EXIT 7') as y from dual;

         Y

----------

         7

SQL> select util.RUN_CMD('C:\WINDOWS\system32\cmd.EXE /c C:\Windows\System32\whoami.exe >jjj_whoami.txt') as y from dual;

         Y

----------

         0

C:\app\oramgr\product\12.1.0\dbhome_1\database>type JJJ.TXT

C:\app\oramgr\product\12.1.0\dbhome_1\DATABASE

C:\app\oramgr\product\12.1.0\dbhome_1\database>type JJJ_WHOAMI.TXT

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2015
Added on Mar 12 2015
8 comments
2,243 views