Re: dbms_utility.get_time (problem executing)

It can for Oracle 8.1.5 anyway...

Try typing

"select dbms_utility.get_time from dual;"

and see what you get.....

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

fumi wrote in message <7o9qa4$pna$2_at_news.seed.net.tw>...
>
>Steve B <steve.bright_at_capgemini.co.uk> wrote in message
>news:7o6b81$5fe$1_at_taliesin.netcom.net.uk...
>> DBMS_UTILITY.GETTIME is a function..
>>
>> Try using
>>
>> select dbms_utility.gettime from dual;
>
>
>The function dbms_utility.get_time CAN'T be used in a SQL statement.
>It can only used in a procedure statement in PL/SQL.
>
>declare
> t number;
>begin
> t:=dbms_utility.get_time;
>end;
>
>
Received on Thu Aug 05 1999 - 03:17:21 CDT