Updating an oracle sequence via plsql
So, my real suggestion would be to create a script that has the commands you want to execute and you run THAT script from the database.Give your self the permission to run that one command -- not /bin/sh Tom, I found this information to be very helpful. I have a question about using the ftp command instead of the ps command. do a dir c:\windows\command.* show us the entire example from the dbms_java calls to the create or replace and compile java source to the call you are doing itself.
TRC Thu Nov 22 2001 ORACLE V22.214.171.124.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 95 V4.10, OS V192.0, CPU type 586 Oracle8i Personal Edition Release 126.96.36.199.0 - Production JServer Release 188.8.131.52.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.
Runtime Permission', 11 '*', 12 'write File Descriptor' ); 13 end; 14 / PL/SQL procedure successfully completed. WORLD Tom- procedure dbms_java.grant_permission is available from 8.1.6.
Is there any workaround available in 8.1.5 to achieve the same functionality. It throws the following error if i try to assign permission to any user...
I've found several examples of these scripts but the "Runtime Power" script on this site does not seem to do anything at all and the other script I've found in an Oracle newsgroup seems to miss some "#import" statements in order to compile correctly. As SYS or some appropriately priveleged user, we will execute: [email protected] begin 2 dbms_java.grant_permission 3 ('RT_TEST', 4 ' IT IS SIMILER EVERY TIME Dump file d:\oracle\admin\swami\udump\ORA51445. If it doesn't, you'll have to find out what that error message is and how to fix it. hi tom finally i am able to run OS command from pl/from Windws NT not Windows 98.
File Permission', 5 '/usr/bin/ps', 6 'execute'); 7 8 dbms_java.grant_permission 9 ('RT_TEST', 10 ' [email protected] From the Java Developers Guide, Part No. TRC Thu Nov 22 2001 ORACLE V184.108.40.206.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 95 V4.10, OS V192.0, CPU type 586 Oracle8i Personal Edition Release 220.127.116.11.0 - Production JServer Release 18.104.22.168.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: 10 Windows thread id: -341771, image: ORACLE. Now I can run os command using extrnal procedure and Java stored procedure.
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.
Creating a standard ftp shell script with predefined input parms is better. From what I can remember the DBMS_PIPE solution (see this site) doesn't have the special character limitation. Apologies for my total lack of java knowledge (I'm getting there...), but your example (which worked fine in 8i) appears to bomb out under my 9i version.
Could you post if the same code works under one of your 9i versions?
JServer Permission exec rc('c:\windows\command /c dir'); Oracle Process.create(Oracle Process.java) at oracle.lang. D:\Oracle\Ora81\DATABASE November 22, 2001 - am UTC Well, it looks like it just started up a command shell -- did not process the "/c dir" part of it (hence the apparent HANG -- it was waiting for someone to type "exit".