Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: running application on the server by issueing an sql query

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

From: Steve <smontgomerie_at_hotmail.com>
Date: 25 Jul 2002 10:17:26 -0700
Message-ID: <156709aa.0207250917.7a53bf16@posting.google.com>


perhaps a conditional pl/sql block that may make a call to the os to execute a program/file ....?

search tom kytes site for pl/sql host java and you can see an example of how to execute os commmands from within pl/sql using java in 8i and higher

"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
Received on Thu Jul 25 2002 - 12:17:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US