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

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 16 Mar 2001 13:40:16 -0800
Message-ID: <F001.002CF814.20010316132828@fatcity.com>

Either
does the 816 version.
<FONT face=Arial color=#0000ff
size=2> 
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....
<FONT face=Arial color=#0000ff
size=2> 
..just
a guess.....

<FONT face="Times New Roman"

  size=2>-----Original Message-----From: Norrell, Brian   [mailto:BNorrell_at_QuadraMed.com]Sent: Friday, March 16, 2001 3:31   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   For You Slick Developers out there.....   

<FONT face=Arial color=navy

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">My   guess is that the 805 version of the package doesn&#8217;t pragma   restrict_references (RNDS,WNDS) like good programmers   should&#8230;
<FONT face=Arial color=navy

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<FONT

  color=navy>Brian
  Norrell<SPAN
  style="COLOR: navy; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 12pt; COLOR: navy">Manager, MPI   Development<SPAN
  style="COLOR: navy; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 12pt; COLOR: red">QuadraMed
<SPAN

  style="FONT-SIZE: 12pt; COLOR: navy">511 E John Carpenter Frwy, Su   500<SPAN
  style="COLOR: navy; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 12pt; COLOR: navy">Irving, TX 75062<FONT 
  color=navy><SPAN 
  style="COLOR: navy; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 12pt; COLOR: navy">(972) 831-6600<FONT 
  color=navy><SPAN 
  style="COLOR: navy; mso-color-alt: windowtext">

<SPAN

  class=EmailStyle16><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original   Message-----From: Mohan,
  Ross [mailto:MohanR_at_STARS-SMI.com]<SPAN   style="FONT-WEIGHT: bold">Sent: Friday, March 16, 2001 1:51   PMTo: Multiple recipients of
  list ORACLE-LSubject: For
  You Slick Developers out there.....
<SPAN

  style="FONT-SIZE: 12pt"> 
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">I get a version-specific glitch ( works   in 816, fails in 805 )<SPAN
  style="COLOR: black"> <SPAN
  style="FONT-SIZE: 10pt; COLOR: black">for a call to the DBMS_UTILITY.GET_TIME   built-in:
<SPAN

  style="COLOR: black; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">######################<FONT 

  color=black> <FONT color=black
  size=2>SQL> select
  dbms_utility.get_time from dual;<SPAN   style="COLOR: black"> <SPAN
  style="FONT-SIZE: 10pt; COLOR: black">select dbms_utility.get_time from   dual
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">         *
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">ERROR at line 1:<FONT   color=black> <FONT color=black
  size=2>ORA-06571: Function
  GET_TIME does not guarantee not to update database<FONT   color=black> <FONT color=black
  size=2><SPAN

  style="FONT-SIZE: 10pt; COLOR: black">######################<FONT 

  color=black> <SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"

  color=black size=3> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">Any ideas why 80520 doesn't like this?
<SPAN

  style="COLOR: black; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">TIA, <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">- Ross<FONT 
  color=black> <SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">p.s.  a simple assignment, like,   for example  time := DBMS_UTILITY.GET_TIME;   
<SPAN

  style="COLOR: black">       
<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">fails as well. <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 10pt; COLOR: black">p.p.s  I know how to use V$TIMER,   so i am looking for a "why this doesn't work"<FONT   color=black>
          <FONT color=black
  size=2>  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:40:16 CST