| executing unix script from oracle proc [message #56777] |
Wed, 23 April 2003 10:25 |
Chandran Gangadharan
Messages: 1
Registered: April 2003
|
Junior Member |
|
|
i've used the method described in this article to execute a proc-
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:952229840241
im able to execute individual unix commands- like ps-ef-
however when i put ps -ef ina script - test.sh
and try and execute the script after running
begin
dbms_java.grant_permission
('TEST',
'java.io.FilePermission',
'/home/test/cplus/test.sh',
'execute');
dbms_java.grant_permission
('TEST',
'java.lang.RuntimePermission',
'*',
'writeFileDescriptor' );
end;
/
it says pl/sql procedure completed but does not show the required info -
i am able to execute the script from the 'oracle' os account.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
