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

I'm new at this.

How do you remotely connect to a machine if the net is not started?

"Shoval Tomer" <shoval_at_softov.co.il> wrote in message news:714a60c1.0207250920.7d8b099b_at_posting.google.com... > "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.