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

[Mohan, Ross]

Title: For You Slick Developers out there.....

Either does the 816 version.   But...i am on the case....i *think* it is likely b/c they declared a global variable in the DBMS_UTILITY ::body:: versus the specification....   ..just a guess..... -----Original Message----- From: Norrell, Brian [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: For You Slick Developers out there..... My guess is that the 805 version of the package doesn’t pragma restrict_references (RNDS,WNDS) like good programmers should…   Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600   -----Original Message----- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Subject: For You Slick Developers out there.....   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,   - Ross   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.