SQL> create or replace type founded_constraint as object(TABLE_NAME varchar2(25), R_TABLE_NAME varchar2(25))
  2  /

Type created.

SQL> create or replace type constraints_table as table of founded_constraint
  2  /

Type created.

SQL> create or replace PROCEDURE detect_one_two_many(p_first_table in varchar2, p_second_table in varchar2)
  2  is
  3  constraints_table_result constraints_table;
  4  begin
  5  
  6   dbms_output.put_line('Hello');
  7  
  8  end detect_one_two_many;
  9  /

Procedure created.

SQL> exec detect_one_two_many('X','Y');
Hello

PL/SQL procedure successfully completed.

SQL>