Problem with dbms_system

[IBI]

Hi,
I'm new using oracle .... I've an NT4 oracle 8.05 server where I want to set trace for a session.
when I run thi command i have this error :

exec dbms_system.set_bool_param_in_session(10,20,'timed statistics',true);
PLS-00201: identifier 'DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION' must be declared

Thanks in advance
ibi

 

[sem]

Use DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure as
SET_BOOL_PARAM_IN_SESSION is not yet implemented in 8.05 (look at DBMS_SYSTEM specification).

Regards, Dima

http://seminihin.narod.ru

 

[IBI]

Thanks for your answer Sem,
I try to change my set but nothing change ...
begin dbms_system.set_sql_trace_in_session(34,3223,true); end;

ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Can you help me ?

 

[sem]

Do you have EXECUTE right on DBMS_SYSTEM package?

Regards, Dima

http://seminihin.narod.ru

 

[IBI]

I 'm enter with system so I can do all ...

 

[sem]

Of course, but only if your sever installed properly

How about

select object_type, owner from dba_objects
where object_name='DBMS_SYSTEM'

Regards, Dima

http://seminihin.narod.ru