RE: [How did I lose the TRUNC() function]

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Fri, 11 Aug 2000 08:09:02 -0400
Message-Id: <10586.114346@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0038C.F06C5E34
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Yigal, no dice. TRUNCATE is not the name of the function, TRUNC is. I = get
the error "identifier 'TRUNCATE' must be declared"

-----Original Message-----
From: Yigal Ran [mailto:ydran_at_usa.net]
Sent: Thursday, August 10, 2000 8:45 PM
To: Multiple recipients of list ORACLE-L Subject: Re: [How did I lose the TRUNC() function]

Replace "TRUNC" with "TRUNCATE".

Yigal

"Koivu, Lisa" <lkoivu_at_qode.com> wrote:

> ---------------------------------------------=20

>	Attachment:=A0=20
>	MIME Type:=A0multipart/alternative=20


> ---------------------------------------------=20

> Putting my developer hat on...=20

>=20

> Check out this error.

>=20

> PLS-00222: no function with name 'TRUNC' exists in this scope
>=20
> How on earth did PL/SQL lose track of the TRUNC function?? Has =
anyone
seen
> this before? FWIW, this is in a cursor.

>=20

> Thanks

>=20

> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319

>=20


> V: 954.484.3191, x174

> F: 954.484.2933=20

> C: 954.658.5849
> http://www.qode.com

>=20
> "The information contained herein does not express the opinion or =
position
> of Qode.com and cannot be attributed to or made binding upon =
Qode.com."
>=20

Get free email and a permanent address at = http://www.amexmail.com/?A=3D1
--=20
Author: Yigal Ran
INET: ydran_at_usa.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C0038C.F06C5E34
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: [How did I lose the TRUNC() function]</TITLE>
</HEAD>
<BODY>

Yigal, no dice. TRUNCATE is not the name of the = function, TRUNC is.  I get the error  "identifier = 'TRUNCATE' must be declared"

-----Original Message----- From: Yigal Ran [<A = HREF=3D"mailto:ydran_at_usa.net">mailto:ydran_at_usa.net</A>]

<BR><FONT SIZE=3D2>Sent: Thursday, August 10, 2000 8:45 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: [How did I lose the TRUNC() =

function]

</P>
<BR>
<BR>

Replace "TRUNC" with = "TRUNCATE".

Yigal

"Koivu, Lisa" <lkoivu_at_qode.com> = wrote:

<P><FONT SIZE=3D2>&gt; --------------------------------------------- =

>       = Attachment:=A0 
 >       MIME = Type:=A0multipart/alternative

<BR><FONT SIZE=3D2>&gt; --------------------------------------------- =
</FONT>
<BR><FONT SIZE=3D2>&gt; Putting my developer hat on... </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Check out this error.</FONT>

> 
 > PLS-00222: no function with name 'TRUNC' exists = in this scope
 > 
 > How on earth did PL/SQL lose track of the TRUNC = function??  Has anyone seen
 > this before?  FWIW, this is in a = cursor.

<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Thanks</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>&gt; Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>&gt; Qode.com</FONT>
<BR><FONT SIZE=3D2>&gt; 4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>&gt; Suite G104</FONT>
<BR><FONT SIZE=3D2>&gt; Fort Lauderdale, FL&nbsp; 33319</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>&gt; F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>&gt; C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2>&gt; <A HREF=3D"http://www.qode.com" =

TARGET=3D"_blank">http://www.qode.com</A> > 
 > "The information contained herein does not = express the opinion or position
 > of Qode.com and cannot be attributed to or made = binding upon Qode.com."

<BR><FONT SIZE=3D2>&gt; </FONT>
</P>
<BR>

<FONT =

SIZE=3D2>_______________________________________________________________=

_____
 Get free email and a permanent address at <A = HREF=3D"http://www.amexmail.com/?A=3D1" = TARGET=3D"_blank">http://www.amexmail.com/?A=3D1</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Yigal Ran</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: ydran_at_usa.net</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 To REMOVE yourself from this mailing list, send an = E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in
 the message BODY, include a line containing: UNSUB = ORACLE-L
 (or the name of mailing list you want to be removed = from).  You may Received on Fri Aug 11 2000 - 07:09:02 CDT