-
Equivalent Host Command in PL/SQL
Hi, I know how to spool from within a procedure by using the UTL_FILE package, so I am spooling a scripted file, now I want to trigger it from inside PL/SQL but I cannot use the HOST command, so what do I use??
Help
-
os utilities - or use java in the database to run host commands
-
Could you give me an example of OS utlities? I saw how to do it in Java and was trying to avoid that route, but I guess if I have to I will.
Do you think someone already has a custom PL/SQL package or procedure to do this? Even if it's written in Java?
Thanks
-
you cant do od commands on pl/sql - its the simple.
So either schedule an OS job (cron or win scheduler) or write some java which can do host calls. asktom.oracle.com has some examples
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
|