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

Home -> Community -> Mailing Lists -> Oracle-L -> For You Slick Developers out there.....

For You Slick Developers out there.....

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 16 Mar 2001 12:00:50 -0800
Message-ID: <F001.002CF5C5.20010316115114@fatcity.com>

I 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
######################

Any ideas why 80520 doesn't like this?

TIA,

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. Received on Fri Mar 16 2001 - 14:00:50 CST

Original text of this message

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