hi,

this is urgent..can i run a shell script from store procedure without using java.

You can with external procedure calls but it's not as simple as invoking a built-in system procedure.

1. Create a shared library with C (.so file)
2. Create a library in PL/SQL (e.g. CREATE OR REPLACE LIBRARY xyz AS '/path/your.so')
3. Create a PL/SQL interface that uses the library (e.g. CREATE OR REPLACE FUNCTION ... RETURN ... EXTERNAL LIBRARY xyz NAME "your_c_function" LANGUATE C;
4. Update your TNSNAMES.ORA to allow external procedure calls
5. Update your listener.ora to allow for external procedure calls

However, having said that, it's probably easier using Java.

can i do this without any lang..

check out these links....where you will get no of methods...

shell script from oracle
other one

The Java solution is simply the best cut it requires specific grants to run various UNIX commands. The first solution using DBMS_PIPE requires that you keep sqlplus resident on a UNIX server for however long that you wish to access UNIX OS commands.

Yes tmarikle you are right Java solution can be considered as best solution and widely used.