Re: dbms_utility.get_time (problem executing)

It's a function. Try

declare
  l_time number;
begin
  l_time := dbms_util.get_time;
  dbms_output.put_line (l_time);
end;
/

Hth
bjin

NetComrade wrote:

> SQL> execute dbms_utility.get_time;
> begin dbms_utility.get_time; end;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00221: 'GET_TIME' is not a procedure or is undefined
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> I have just ran the dbmsutl.sql before trying to execute it.
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Mon Aug 02 1999 - 21:49:35 CDT