An error occurred while updating the entries savechanges
When I run the ps command everything work fine, but when I run the ftp command ("/usr/bin/ftp -vin January 17, 2002 - am UTC ftp is waiting for the username and password to be entered and ftp refuses to read this from stdin as you are trying (i assume you have the username/password in the parfile.txt) Do a man on netrc to see how to setup a .netrc (in the ORACLE account -- could be somewhat "dangerous").
A better approach might be to use some java classes that let you PROCEDURALLY do an ftp from java -- in that fashion, you can alleviate the inherit security issues with the .netrc file solution.
Your information about using .netrc worked to some degree. In my comments higher up I referred to writing the command to a file, doing a chmod x etc.
I woks when I run the ftp command from the unix prompt, but it still hangs when I attempt to execute from SQL*PLUS. Obviously that's only if you don't know the command you want to run.
PLS-00302: component 'GRANT_PERMISSION' must be declared thanks, senthil April 29, 2002 - pm UTC There is JAVASYSPRIV (a role) you can grant but beware -- it is "all powerful".
Runtime Permission', '*', 'write File Descriptor' ); -- try to accomodate input redirection dbms_java.grant_permission ('SCOTT', '
Runtime Permission', '*', 'read File Descriptor' ); -- try to accomodate input/output redirection ('SCOTT', '
File Permission', '/tmp/*', 'read,write'); -- commit; end; / 2.) changed RC to output the return code: CREATE OR REPLACE procedure RC(p_cmd in varchar2) as x number; begin x := run_cmd(p_cmd); DBMS_OUTPUT.
TRC Thu Nov 22 2001 ORACLE V220.127.116.11.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 95 V4.10, OS V192.0, CPU type 586 Oracle8i Personal Edition Release 18.104.22.168.0 - Production JServer Release 22.214.171.124.0 - Production Windows 95 V4.10, OS V192.0, CPU type 586 Instance name: swami Redo thread mounted by this instance: 1 Oracle process number: 13 Windows thread id: -710243, image: ORACLE.
hi tom it was dir c:\windows\when i run exec rc('c:\windows\/c dir'); it never come back i examined udump file it looks like Dump file d:\oracle\admin\swami\udump\ORA10653.