Re: running application on the server by issueing an sql query

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3d3fcebe$0$231$ed9e5944_at_reading.news.pipex.net>...
> 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

The purpose of doing this is quite simple. We only have access to the servers via SQL*NET or PC Any Where, however, when pc any where remote control session crashes you cannot reconnect unless someone restarts the pc any where host service. I wanted to find a way to do this remotely, and my only option is via Oracle.

I'll look into external procedure calls.

Thanks guys. Received on Thu Jul 25 2002 - 12:20:48 CDT