how to get output from stored procedure in oracle
-- SQL Developer : show View | DBMS Output > Add connection (+)
SET SERVEROUTPUT ON;
DECLARE
v_name VARCHAR2(50) := 'Bond';
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello !');
DBMS_OUTPUT.PUT_LINE('My name is ' || v_name);
END;