Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    MADRID, SPAIN
    Posts
    2

    Question Unanswered: Drop Public Synonym From A Package

    IS IT POSSIBLE TO DROP PUBLIC SYNONYM FROM A PROCEDURE WITHIN A PACKAGE?

    I am trying to do somethig like

    EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM SYNONYM_' || vCounter;

    It gives me error ORA-01031; however, when I drop the public synonym directly from SQL*Plus it works.

    Any idea?

  2. #2
    Join Date
    Mar 2003
    Location
    MADRID, SPAIN
    Posts
    2

    Talking

    Proble solved. I needed the DROP PUBLIC SYNONYM privilege and I had the DROP ANY SYNONYM one instead.

    Thanks for your interest.


    Best regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •