Message-Id: <10586.114346@fatcity.com> From: "Koivu, Lisa" Date: Fri, 11 Aug 2000 08:09:02 -0400 Subject: RE: [How did I lose the TRUNC() function] 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@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" 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@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@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 RE: [How did I lose the TRUNC() function]

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@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@qode.com> = wrote:

> --------------------------------------------- =
>       = Attachment:=A0
>       MIME = Type:=A0multipart/alternative
> --------------------------------------------- =
> Putting my developer hat on...
>
> Check out this error.
>
> 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.
>
> Thanks
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL  33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> http://www.qode.com
>
> "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."
>


_______________________________________________________________= _____
Get free email and a permanent address at http://www.amexmail.com/?A=3D1
--
Author: Yigal Ran
  INET: ydran@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@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