-
Calling Batch file from PL/Sql or Trigger
hi all,
i am using oracle 9.2. I want execute a batch file from pl/sql or trigger. is it possible. if possible then what will be the code.
regards
sakil
-
nope, not from plsql you cant
-
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
you can execute a batch file with a java procedure EXECOSCMD or EXECUTEOSCMD .
You need to set the utl_file_dir database parameter to where your batch is located in the server,so you ll let oracle to access the path that you mention.
Then you can use execoscmd to run a bash script or any program on the server.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|