look into external procedure calls. This can do the job you are asking.
However to set it up you'd need access to the server anyway so you could
achieve this from the os management tools.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Shoval Tomer" <shoval_at_softov.co.il> wrote in message
news:714a60c1.0207242337.4804da2b_at_posting.google.com...
> we're running Oracle 8.1.7 on Windows 2K.
>
> Is there a way to issue an SQL query that will run an exe on the
> server?
>
> Let's say I'd like to start an OS service, I'd like to issue the
> command 'net start <service name>' through oracle which is the only
> way I can connect to the server.
>
> Something like the xp_cmdshell on MSSQL server.
>
> Thanks
Received on Thu Jul 25 2002 - 05:11:09 CDT
