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

Bill,

EXEC works fine, however, your command has to be ON ONE LINE only

Try

SQL> EXEC DBMS_RESOURCE_MANAGE_PRIVS.GRANT_SYSTEM_PRIVILEGE(Grantee_name => 'SCOTT', PRIVILEGE_NAME => 'ADMINISTER_ RESOURCE_ MANAGER', Admin_Option = False );

Otherwise just wrap it in BEGIN...END.

M

"Bill" <bill200_at_hotmail.com> wrote in message news:<ZIhC8.1059$w27.657326_at_news20.bellglobal.com>...
> 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 Thu May 09 2002 - 05:11:32 CDT