CREATE or replace PROCEDURE addtuple3( b OUT NUMBER)
    AS
    C NUMBER;
    BEGIN
        b := 4;
        SELECT C INTO E FROM G100;
    END;
/

Procedure created.

SQL>
 DECLARE
     v NUMBER;
  BEGIN
     addtuple3(v);
  END;
/

SQL> CREATE or replace PROCEDURE addtuple3( b OUT NUMBER)
  2      AS
  3      C NUMBER;
  4      BEGIN
  5          b := 4;
  6          SELECT C INTO E FROM G100;
  7      END;
  8  /

Warning: Procedure created with compilation errors.

SQL> DECLARE
  2       v NUMBER;
  3    BEGIN
  4       addtuple3(v);
  5    END;
  6  /
     addtuple3(v);
     *
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00905: object MICHEL.ADDTUPLE3 is invalid
ORA-06550: line 4, column 6:
PL/SQL: Statement ignored

SQL> CREATE or replace PROCEDURE addtuple3( b OUT NUMBER)
  2      AS
  3      E NUMBER;
  4      BEGIN
  5          b := 4;
             --the below sql is returning no rows
  6          SELECT C INTO E FROM G100;
  7      END;
  8  /

SQL> CREATE or replace PROCEDURE addtuple3( b OUT NUMBER)
  2      AS
  3      C NUMBER;
  4      BEGIN
  5          b := 4;
  6          select 1 into c from dual where 1=0;
  7      END;
  8  /

Procedure created.

SQL> DECLARE
  2       v NUMBER;
  3    BEGIN
  4       addtuple3(v);
  5       dbms_output.put_line(v);
  6    END;
  7  /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "MICHEL.ADDTUPLE3", line 6
ORA-06512: at line 4

SQL> DECLARE
  2       v NUMBER;
  3    BEGIN
  4       addtuple3(v);
  5       dbms_output.put_line(v);
  6    exception when no_data_found then dbms_output.put_line(v);
  7    END;
  8  /


PL/SQL procedure successfully completed.

SQL> DECLARE
  2       v NUMBER := 0;
  3    BEGIN
  4       addtuple3(v);
  5       dbms_output.put_line(v);
  6    exception when no_data_found then dbms_output.put_line(v);
  7    END;
  8  /
0

PL/SQL procedure successfully completed.

SQL> CREATE or replace PROCEDURE addtuple3( b OUT NOCOPY NUMBER)
  2      AS
  3      C NUMBER;
  4      BEGIN
  5          b := 4;
  6          select 1 into c from dual where 1=0;
  7      END;
  8  /

Procedure created.

SQL> DECLARE
  2       v NUMBER := 0;
  3    BEGIN
  4       addtuple3(v);
  5       dbms_output.put_line(v);
  6    exception when no_data_found then dbms_output.put_line(v);
  7    END;
  8  /
4

PL/SQL procedure successfully completed.