CREATE OR REPLACE PROCEDURE TEST IS VAR VARCHAR2(20); BEGIN SELECT ITEM INTO VAR FROM ITEM_TABLE; END;