Oracle Database Discussions

Hi all,

To run program.exe In sql*plus, I use :
SQL> $program.exe
and it works perfectly.

Now, I need to run the same program.exe from pl/sql code.
the '$' is no more usable in this context. so I tried with the HOST command (or procedure) but it is not recognized. perhaps it was deleted or something like that.

does someone know how to perform this operation? I mean what can I do to make HOST available for use?

I already tried with creating HOST procedure as following but it was created with errors.

SQL> create procedure host( cmd in varchar2 )
as
status number;
begin
dbms_pipe.pack_message( cmd );
status := dbms_pipe.send_message( 'HOST_PIPE' );
if ( status <> 0 ) then raise_application_error( -20001, 'Pipe error' );
end if;
end;
/

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE HOST:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/5 PLS-00201: identifier 'DBMS_PIPE' must be declared
5/5 PL/SQL: Statement ignored
6/5 PL/SQL: Statement ignored
6/15 PLS-00201: identifier 'DBMS_PIPE' must be declared

Any idea please?