How to execute OS Command

[druide]

hi !

Is there a way to run OS Command ? With a package for example ?

druide

[julian]

Tim Hall has a great site, I hope this is what U R looking 4:

http://www.oracle-base.com/Articles/...sFromPLSQL.asp

[druide]

Thanks a lot, that's what I am loking but unfortunately, it works for Oracle 8i and 9i and my problem is for Oracle 8.0.6.
Any other suggestion ?

[pando]

go to metalink and look

For unix :
a. Calling Operating System Commands from PL/SQL using External Procedures Note:99136.1
b. Dynamic SQL and System Commands Using DBMS_PIPE Note:14082.1

For Windows :
a. How to Launch Windows NT OS Commands From an External Procedure Note:130799.1
b. How to Execute NT Operating System Command From PL/SQL Note:136527.1



a. How to perform FTP operations from within PL/SQL (part I) Note:159034.1
b. How to perform FTP operations from within PL/SQL (part II) Note:159061.1
c. How to perform FTP operations from within PL/SQL (part III) Note:159062.1
@ Execute remote shell script through external procedure Note:111780.1
d. How to perform FTP operations from within PL/SQL,external procedure Part 1,2,3 Note:163737.1,
Note:163738.1,
Note:163739.1