Problems with Select with Into in Procedure
503412Sep 2 2009 — edited Sep 2 2009Why this procedure has an error in Select clausule?
CREATE OR REPLACE Procedure pr_purge_partitions (DATAREF number) is
MMDDREF varchar(4);
DATAREF_INI DATE;
TEXT varchar(9);
BEGIN
DATAREF_INI := TO_DATE(DATAREF,'YYYYMMDD') - 91;
MMDDREF := TO_CHAR(DATAREF_INI, 'MMDD');
SELECT
Tbl.PARTITION_POSITION INTO TEXT
FROM
USER_TAB_PARTITIONS Tbl
WHERE
Tbl.TABLE_NAME = 'USER'
AND
Tbl.PARTITION_NAME = 'USER_P' || MMDDREF;
dbms_output.put_line('Text: '|| TEXT );
END;