quick pl/sql question
- From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 17:05:50 +0100
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
