quick pl/sql question

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Wed, 21 Apr 2004 17:05:50 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E629EA5@louis.cerebrus.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Apr 21 2004 - 11:00:06 CDT