Re: How to execute a buit-in package's procedure?

Now I understand, if I use
 BEGIN
 .....
 .....;
END;
all the procedures are executed successfully. So I think the EXEC is misleading in the manuals. It won't work! Thanks!

Bill

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CD991D0.9D66DACD_at_exesolutions.com...
> Bill wrote:
>
> > I tried to grant a system privilege ADMINISTER RESOURCE MANAGER to user
> > scott.
> > I used the DBMS_RESOURCE_MANAGER_PRIVE package to do the job. According
to
> > the Oracle8.1.6 manual, I used the following command :
> >
> > EXEC DBMS_RESOURCE_MANAGE_PRIVS.GRANT_SYSTEM_PRIVILEGE
> > (Grantee_nmae => 'SCOTT',
> > PRIVILEGE_NAME => 'ADMINISTER_ RESOURCE_ MANAGER',
> > Admin_Option = False );
> > But the command won't work. It seems there is no such an EXEC command
in
> > Oracle server, but it appears every where in the manuals. Any help,
please.
> >
> > Bill
>
> EXEC is definitely a command. But 'Grantee_nmae' is a non-starter.
>
> Please post the actual error message you are receiving from ORA- to the
end.
>
> Daniel Morgan
>
Received on Wed May 08 2002 - 17:33:08 CDT