Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with Select with Into in Procedure

503412Sep 2 2009 — edited Sep 2 2009
Why 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;

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 30 2009
Added on Sep 2 2009
5 comments
335 views