Re: Execute a batch file from a trigger or a SP?

<grille11_at_yahoo.com> wrote in message
news:c6if9f$hn0$1_at_reader1.imaginet.fr...
> Hello,>> I am trying to execute a batch file (containing a rundll32 command line)> using a trigger or a stored procedure.> Here is a trigger with which I retreive a variable (@nDocID) that I want
to
> use in my SP (sp_batch).>> Declare @nDocID Integer> Declare @doctypeID Integer> Select @nDocID = doc_id> From Updated> IF @doctypeID <> @nDocID> Begin> exec sp_batch @nDocID> End>> and my sp looks like this:> rundll32 c:\app\file.dll,Function>> In SQL we can use EXEC master..xp_cmdshell sp_batch @nDocID> Would there be an equivalent?>> I hope someone will be able to bring light to my darkness>> thanks>>

There is no such command in SQL (Structured Query Language). There may be a
command in MS Sql Server's dialect of SQL. You can do this in Java and load
the Java program into Oracle. See asktom.oracle.com and do a search.
Jim
Received on Mon Apr 26 2004 - 04:44:25 CDT