| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: quick pl/sql question
Dave:
Not sure, but it appears that you may not have the correct privileges to use the DBMS procedures within a created procedure. You may have to grant additional access on this procedure to accomplish what you need. Just a thought.
Thank You
Stephen P. Karniotis
Compuware Corporation
Direct: (313) 227-4350
Toll Free: (800) 462-7740 ext. 74350
Mobile: (248) 408-2918 Email: Stephen.Karniotis_at_Compuware.com Web: www.compuware.com -----Original Message----- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: Wednesday, April 21, 2004 12:06 PM To: oracle-l_at_freelists.org Subject: quick pl/sql question
Got this simple proc
SQL> create or replace procedure dave_test (p_user_id IN varchar2) as
begin
dbms_resource_manager_privs.grant_switch_consumer_group(p_user_id,'users 1',TRUE); dbms_resource_manager.set_initial_consumer_group(p_user_id,'users1');
end;
/
exec dave_test('ds');
*
ERROR at line 1:
ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_RMIN", line 56 ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER_PRIVS", line 99 ORA-06512: at "CEREBRUS.DAVE_TEST", line 3 ORA-06512: at line 1
How do I do this in pl/sql?
I can do it from the command line
SQL> exec
dbms_resource_manager_privs.grant_switch_consumer_group('ds','users1',TR
UE);
PL/SQL procedure successfully completed.
SQL> exec
dbms_resource_manager.set_initial_consumer_group('ds','users1');
PL/SQL procedure successfully completed.
Thanks
Dave
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
 |
 |