How to run an host command from oracle ?

[lecorr]

Hi,

I need to run an host command (EXP ...) from my PL SQL code. I heard about doing this through a java function. Does someone knows about this?

Thanks.

 

[sem]

I wrote an answer some time ago, just look for it in this forum.

Regards, Dima

http://seminihin.narod.ru

 

[lecorr]

Hi,

Thank you Sem for your help. It was a bit difficult to find the info.
I put here the needed links:
Without the use of Java:

http://asktom.oracle.com/pls/ask/f?...0_P8_DISPLAYID,F4950_P8_CRITERIA:16212348050,

With Java:

http://asktom.oracle.com/pls/ask/f?...0_P8_DISPLAYID,F4950_P8_CRITERIA:952229840241

But this is mainly for V8.

Knowing that we DO NOT use java, does anyone know about an easier way with V9... possibly with source in C or COBOL?

Note that in V10, dbms_scheduler allows to run OS commands.


Thanks