conn
/as
sysdba
desc dbms_pipe
if exists then
grant execute on dbms_pipe to username ;
else
start ?/ rdbms / admin / dbmsalrt . sql ;
grant execute on dbms_pipe to username ;
end if;
desc dbms_pipe
if exists then
grant execute on dbms_pipe to username ;
else
start ?/ rdbms / admin / dbmsalrt . sql ;
grant execute on dbms_pipe to username ;
end if;