select object_type, object_name --esta consulta nos indica que procedimiento hemos creado
from user_objects
  where object_type='PROCEDURE' or
    object_type='FUNCTION';
   
    --Para eliminar un procedimiento/funcion
    drop procedure <procedure_name>;
    drop function <function_name>;

--------------------------------------------------------------------------------------------------------------------------create or replace function validaCliente (pNumCliente varchar2) ---Esta funcion sirve para validar al cliente
  return boolean
    is
        vNumCliente Cliente.numCliente%TYPE;
      begin
         select numCliente into vNumCliente
         from Cliente
         where numCliente=pNumCliente;
         return TRUE;
      Exception
         When no_data_found then
         return FALSE;
         end;

--------------------------------------------------------------------------------