Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NT operating system command from PL/SQL

Status
Not open for further replies.

vrudenko

Programmer
Feb 23, 2001
28
CA
Hi,

I need to execute Windows NT operating system commands from stored procedures (PL/SQL).

Thank you for any help

Vira

 
Host only works from SQL*Plus, not a stored procedure.
 
Your answer is Oracle data cartrige, your dba needs to do some initial setup for the purpose.

Contact your dba!!
 
Hi all,

Thank you for help!
Unfortunately, my company does not have an Oracle DBA. So, I have to solve the question myself.

Vira
 
if all else fails,
find code for a daemon that
will listen for commands via a pipe.
You can find code like that on the
internet, or in oracle's book on
your version of oracle.
In the stored procedure, pipe the
command to the daemon, which
will execute it. Well, in unix
it's called a daemon, in NT I'm
not sure. Jim

oracle, vb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top