Re: Calling OS command from stored procedure

I don't know how to do this simply, but a do know a way to do it.

Basically, what you do is cause the stored procedure to write to a pipe. There is an Oracle package called DBMS_PIPE which is created by the catproc.sql script, probably during installation. If its not already created, then it needs to be run by the user 'SYS'. This package allows writing to and reading from pipes.

You need to give execute permission on the package to the appropriate Oracle accounts.

More specifics on this are available in the Applications Developers Guide, and I may be able to help you a little as well.

-- 
Andrew McConnell             "Ford!" he said, "there's an infinite number of
Voice: (304) 594-9819      monkeys outside who want to talk to us about this 
FAX:   (304) 594-3951      script for 'Hamlet' they've worked out."
mcconnel_at_source.asset.com                                    -- Arthur Dent