"SP" <sdpantDeleteThisToReply_at_yahoo.com> a écrit dans le message de
news:5iHEb.47170$vn.111489_at_sea-read.news.verio.net...
> Sorry I didn't mention my problem. The 'create synonym...' should be
> running instead it's going to error handler. Any idea why it is so?
> SP
> "Frank" <fbortel_at_nescape.net> wrote in message
> news:brvejc$u56$1_at_news4.tilbu1.nb.home.nl...
> > 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
> >
>
Maybe roles are not enable in package? ;-)
Michel Cadot
Received on Fri Dec 19 2003 - 13:51:48 CST
