Re: running into problem with package.

SP wrote:

> Hi all,
> I'll explain this first. First, synonym STATUS for userA is dropped if one
> exists for that user otherwise will go to exception handler. After the
> first drop statement there shouldn't be any synonym named 'STATUS' owned by
> userA. But on execution they both are being handled by exception handler.
> But when I run seperately they run just fine. It's not the permission issue
> as this statement is being run by a account with DBA privilege and when the
> statements are run seperately (not from inside package) they just run fine.
> Any help would be appreciated.
> TIA,
> SP
>
> CREATE OR REPLACE PACKAGE TEST_Utilities
> AS
> PROCEDURE SwitchToSourceA;
> END TEST_Utilities;
> /
> CREATE OR REPLACE PACKAGE BODY TEST_Utilities IS
> PROCEDURE SwitchToSourceA IS
> BEGIN
> BEGIN EXECUTE IMMEDIATE ('DROP SYNONYM userA.STATUS'); EXCEPTION WHEN
> OTHERS THEN NULL; END;
> BEGIN EXECUTE IMMEDIATE ('CREATE SYNONYM userA.STATUS FOR
> userB.STATUS'); EXCEPTION WHEN OTHERS THEN NULL; END;
> END SwitchToSourceA;
>
> END;
> /
>
>

What is the problem?

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel