If I execute this line, it perfectly shows the output of the DBMS
BEGIN
DBMS_OUTPUT.PUT_LINE('HOLA');
END;
but when executing this process
DECLARE
CURSOR mayor_valor IS
SELECT nombre, descripcion
FROM producto
WHERE precio = (SELECT MAX(precio) FROM producto);
BEGIN
FOR maximo IN mayor_valor LOOP
DBMS_OUTPUT.PUT_LINE('Producto con mayor precio: ' ||maximo.nombre);
DBMS_OUTPUT.PUT_LINE('Descripcion: ' || maximo.descripcion);
END LOOP;
END;
I only get it
PL / SQL procedure terminated correctly.
This block worked perfectly in a computer room of the university, but not here in my house. I also have another file that contains a package with 2 procedures, and when executing these, the output of the DBMS works perfectly.
