You created a procedure as follows: CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2) IS stmt VARCHAR2(100); pname VARCHAR2(20); BEGIN stmt:='SELECT product...