Passing string variable into WHERE IN statement at another procedure

Question

I have a variable call Name in a Procedure call getName

Dbms_Output.Put_Line('Name : ' || Name);

Output result
-------------
Name : 'John', 'Test'

However when I try pass in the Name variable into 'Where IN ()' statement in another procedure, it doesn't work. Any idea?

Where Name IN (Name);

Wouldn't that statement equivalent to

Where Name IN ('John', 'Test');