It is NOT misleading, it is a SQL*PLUS thingy.
Try to read more accurate.
Regards
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"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 Wed May 08 2002 - 23:40:36 CDT
