How to create folder using PLSQL in Windows?
1. First of all starts the OracleJobSchdulerXE service.
2. Find cmd.exe in your system and copy path.
3. Then use following command. i.e. To create test2 folder inside utl folder "E:\Anuj\utl\test2"
where E:\Anuj\utl\ is base path
where E:\Anuj\utl\ is base path
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'create_dir_test',
job_type => 'executable',
job_action => 'C:\Windows\WinSxS\wow64_microsoft-windows-commandprompt_31bf3856ad364e35_6.2.9200.16384_none_ee2b1873d8818161\cmd.exe /c mkdir E:\Anuj\utl\test2',
enabled => TRUE,
auto_drop => TRUE);
COMMIT;
END;
/
No comments:
Post a Comment
Please do not add any spam links or abusive comments.