Originally posted by coleex
I need to know if there is a package in oracle 7.3.4 that will allow me to send a sql plus command from a procedure/ pl/sql block? I need to send the command "net send username . I know using the HOST command allow this to happen in sql*plus but I it to be ran from a procedure. Any ideas on how to do this?
No, there is no such, package. In 7.3 you can't even use external procedures, so the only option is to use DBMS_PIPE and a "deamon listener". Very messy stuff....

But does this "net send..." has to be executed sinchronously? If this is not very strict demand you could take advantage of UTL_FILE package to write command to some batch file and have OS scheduler periodically check for this batch file and execute it.