Running system commands in PL/SQL in Oracle 7 NT 4

[SpiritOfLennon]

Hi
Does anyone know how to run system commands from within PL/SQL in Oracle 7 running on an NT platform. I know it is possible on Oracle 8 on Unix, does the same technique apply? SOL
Yeah people they won't understand,
Girlfriends they don't understand,
In spaceships they don't even understand,
and me I aint ever gonna understand

 

[sem]

You may use sqlplus (GUI: plus3*.exe, TEXT: sqlplus.exe). It may be found in ORACLE_HOME\bin.
Another program is Server Manager (svrmgr3*.exe)

* depends on your release.

 

[SpiritOfLennon]

Either I'm being real thick ( which is a possibility ) or I haven't explained myself very well. What I want to do is run a command line ( or batch file ) from within the body of a trigger as I need to run an application interface program when records are created in a specific Oracle staging table, in order to process these rows. SOL
I'm only guessing but my guess work generally works for me.

 

[sem]

Oops. There is no "authentic" way. You may run some daemon on Pro*C/OCI/Java/WhateverElse and communicate with it via pipe.

 

[SpiritOfLennon]

Okay so it appears to be a similar process as on a unix system. Does anybody have any practical examples or links they could provide, that would be real nice. Thanks. SOL
I'm only guessing but my guess work generally works for me.