SQL> grant execute on SYS.DBMS_UTILITY to TEST; Grant succeeded. SQL> grant execute on SYS.DBMS_UTILITY.GET_PARAMETER_VALUE to TEST; grant execute on SYS.DBMS_UTILITY.GET_PARAMETER_VALUE to TEST * ERROR at line 1: ORA-00905: missing keyword --Attempt at running function logged on as Test user: SQL> conn Test/test Connected. SQL> SQL> DECLARE 2 parnam VARCHAR2(256); 3 intval BINARY_INTEGER; 4 strval VARCHAR2(256); 5 partyp BINARY_INTEGER; 6 BEGIN 7 partyp := dbms_utility.get_parameter_value('open_cursors', 8 intval, strval); 9 dbms_output.put('parameter value is: '); 10 IF partyp = 1 THEN 11 dbms_output.put_line(strval); 12 ELSE 13 dbms_output.put_line(intval); 14 END IF; 15 IF partyp = 1 THEN 16 dbms_output.put('parameter value length is: '); 17 dbms_output.put_line(intval); 18 END IF; 19 dbms_output.put('parameter type is: '); 20 IF partyp = 1 THEN 21 dbms_output.put_line('string'); 22 ELSE 23 dbms_output.put_line('integer'); 24 END IF; 25 END; 26 / DECLARE * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_UTILITY", line 140 ORA-06512: at line 7
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE