what's ur idea about this two way for creat a folder in oracle

Posted by rima on Stack Overflow See other posts from Stack Overflow or by rima
Published on 2010-06-07T04:01:41Z Indexed on 2010/06/07 4:12 UTC
Read the original article Hit count: 355

Filed under:
|
|

According to my last question about how to create folder here I find some codes that s.b before write it!
looking :
(sorry for limitation i cant put codes here)
they try to Create a bat file,by oracle

outfile text_IO,file_type
then they write these statement!
body_of_file = 'Net use x: \\address'
body_of_file += 'md' || filename
body_of_file += 'start '|| file name

then open bat file and write inside it!

then they call it by HOST!!!!
like:

Host('cmd /c \\address\.x.bat host_folder'|| sysdate);

but they can easily and directly by calling HOST!
and also I dont know why they code just can in oracle 6i!!!! we use 2 oracle 6i and 10g.

please would you help me :
1- why this code dont work in 10g?
2- which way is better?create a batch file and create folder or use HOST for run each command?(in my Idea both is same,How about u?)

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about oracle10g