Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: For You Sticky Developers out there.....

RE: For You Sticky Developers out there.....

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 16 Mar 2001 18:33:06 -0800
Message-ID: <F001.002CFB56.20010316182527@fatcity.com>

>-----Original Message-----
>From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]
>
>get a version-specific glitch ( works in 816, fails in 805 )
>for a call to the DBMS_UTILITY.GET_TIME built-in:
>
>######################
>SQL> select dbms_utility.get_time from dual;
>select dbms_utility.get_time from dual
>       *
>ERROR at line 1:
>ORA-06571: Function GET_TIME does not guarantee not to update database
>######################
>
>p.s.  a simple assignment, like, for example
>  time := DBMS_UTILITY.GET_TIME;
>        fails as well.
>p.p.s  I know how to use V$TIMER, so i am looking for
> a "why this doesn't

work"
>          not a "How to fix it by using V$TIMER"  answer.

I don't know what to tell you. I ran the following SQL*Plus statements in Oracle 7.3.4, 8.0.5 and 8.1.6 without any errors:

SQL> var n number
SQL> begin

  2     :n := dbms_utility.get_time ;
  3  end ;
  4  /


PL/SQL procedure successfully completed.

SQL> print n

         N



 279430259 Received on Fri Mar 16 2001 - 20:33:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US