jl66
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??
in pl/sql procedure p1, want to run
copy /y c:\temp\a.txt d:\temp\b.txt
How to do that??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The issue was resolved. Thanks a lot for everyone's tip.
ASKER
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.