Link to home
Start Free TrialLog in
Avatar of jl66
jl66Flag for United States of America

asked on

How to execute a DOS shell command in a pl/sql procedure?

Have a need to run a DOS commads in a pl/sql procedure. For example,

in pl/sql procedure p1, want to run
copy /y c:\temp\a.txt d:\temp\b.txt
How to do that??
SOLUTION
Avatar of cheers4beers
cheers4beers
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jl66

ASKER

Thanks so much for everyone's tips.
slightwv:
One quetion is related to your approach: in PL/SQL procedure p1, how to create a DIRECTORY? Like

execute immediate create or replace directory USER_DIR1 as 'C:\temp';

It did not work.
Avatar of jl66

ASKER

The issue was resolved. Thanks a lot for everyone's tip.