Oracle Database Discussions

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!

DROP DB Link within PL/SQL proc.

Gaétan FrancoeurOct 19 2004 — edited Oct 19 2004

Hi,

In a PL/SQL procedure and I have to delete and recreate a DB Link within a cursor. The DB Link has always the same name but the definition changes depending of some parameters. If I add DBMS_SESSION.CLOSE_DATABASE_LINK(my_dblink) and EXECUTE IMMEDIATE 'DROP DATABASE LINK my_dblink', I got this error message ORA-00439: feature not enabled: Enterprise User Security. If I don't use DBMS... I got ORA-02011: duplicate database link name. So, it seems I'm unable to delete and recreate a DB Link within my cursor. Any idea what's wrong?
Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2004

Added on Oct 19 2004

#general-database-discussions

8 comments

536 views