var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
Proble solved. I needed the DROP PUBLIC SYNONYM privilege and I had the DROP ANY SYNONYM one instead.
Thanks for your interest.