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!

Package becomes invalid after dropping a partition

jakaur-OracleApr 10 2006 — edited Apr 12 2006

Hi,

I am using Oracle 9i DB (9.2.0.6) and I've a package that contains two procedures ( ProcA and ProcB). ProcA creates a partition for tableA and inserts records into that table. ProcB moves the records (after processing) from TableA to TableB and drops the partition.

This code works fine in 10g. However, in Oracle 9i, the package becomes invalid and start displaying ORA-04068 error messages when executed.

If I comment out the drop partition line (EXECUTE IMMEDIATE 'ALTER TABLE TABLEA DROP PARTITION p_'||id), then it works fine.

Any clue as to how can I make this package work in 9i.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2006

Added on Apr 10 2006

8 comments

719 views