HI,
can anyone tell me how to use the host command in nt
i want to launch a bat file from a stored proc and it's not working thanks
Printable View
HI,
can anyone tell me how to use the host command in nt
i want to launch a bat file from a stored proc and it's not working thanks
You'll need to use a standard package to run OS commands from a database stored procedure. You can run OS commands from program units developed as part of a form using the HOST command . . .
The popular and easy way is developed a java program package and load in satabase(or sipmply created in database), then create a procedure to call that program. At last call this procedure where you want to process the bat file with passing in the command as string parameter. This will not require lot of java knowledge but follow the procedures.
Again visit this site:
http://osi.oracle.com/wa/ask/owa/ask...d=952229840241
OR visit oracle magazine in MARCH/APRIL volume on line
just follow the procedures.
Take care