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

From: Norrell, Brian <BNorrell_at_QuadraMed.com>
Date: Fri, 16 Mar 2001 13:15:28 -0800
Message-ID: <F001.002CF683.20010316123034@fatcity.com>

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>My guess is that the 805 version of the package doesn&#8217;t pragma restrict_references (RNDS,WNDS) like good programmers should&#8230;

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<font

color=navy>Brian Norrell<font
color=navy>

<span

style='font-size:12.0pt;color:navy'>Manager, MPI Development<font color=navy>

<span

style='font-size:12.0pt;color:red'>QuadraMed

<span

style='font-size:12.0pt;color:navy'>511 E John Carpenter Frwy, Su 500<font color=navy>

<span

style='font-size:12.0pt;color:navy'>Irving, TX 75062<font color=navy>

<span

style='font-size:12.0pt;color:navy'>(972) 831-6600<font color=navy>

<span

class=EmailStyle16><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span style='font-size:

10.0pt;font-family:Tahoma;color:black'>-----Original Message----- From: Mohan, Ross
[mailto:MohanR_at_STARS-SMI.com]
Sent: Friday, March 16, 2001 1:51
PM
To: Multiple recipients of list
ORACLE-L
Subject: For You Slick Developers
out there.....

<span style='font-size:

12.0pt'> 

<span style='font-size:10.0pt;

color:black'>I get a version-specific glitch ( works in 816, fails in 805 )<font color=black>
<span style='font-size:10.0pt;

color:black'>for a call to the DBMS_UTILITY.GET_TIME built-in:<font color=black> <span
style='color:black;mso-color-alt:windowtext'>

<span style='font-size:10.0pt;

color:black'>######################<span

style='color:black'>
<span style='font-size:10.0pt;

color:black'>SQL> select dbms_utility.get_time from dual;<font color=black>
<span style='font-size:10.0pt;

color:black'>select dbms_utility.get_time from dual<font color=black>
<span style='font-size:10.0pt;

color:black'>       *<font
color=black>
<span style='font-size:10.0pt;

color:black'>ERROR at line 1:<span
style='color:black'>
<span style='font-size:10.0pt;

color:black'>ORA-06571: Function GET_TIME does not guarantee not to update database
<span style='font-size:10.0pt;

color:black'>######################<span

style='color:black'> <span style='color:black; mso-color-alt:windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span style='font-size:10.0pt;

color:black'>Any ideas why 80520 doesn't like this? <font color=black>

<span style='font-size:10.0pt;

color:black'>TIA, <span style='color:black; mso-color-alt:windowtext'>

<span

style='font-size:12.0pt;color:black'> <font color=black>

<span style='font-size:10.0pt;

color:black'>- Ross <font
color=black>

<span

style='font-size:12.0pt;color:black'> <font color=black>

<span style='font-size:10.0pt;

color:black'>p.s.  a simple assignment, like, for example  time := DBMS_UTILITY.GET_TIME;    <span
style='color:black'>
        <font size=2
color=black>fails as well. <font
color=black>

<span style='font-size:10.0pt;

color:black'>p.p.s  I know how to use V$TIMER, so i am looking for a "why this doesn't work"<span
style='color:black'>
        <font size=2
color=black>  not a "How
to fix it by using V$TIMER"  answer. <span style='color:black;mso-color-alt:windowtext'> Received on Fri Mar 16 2001 - 15:15:28 CST