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

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 11 Aug 2000 16:08:19 -0400
Message-Id: <10586.114407@fatcity.com>

What is the status of the package standard? Did you try re-running standard.sql as sys?

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Friday, August 11, 2000 11:48 AM
To: Multiple recipients of list ORACLE-L Subject: 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_at_usa.net <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:

> ---------------------------------------------
> Attachment:
> MIME Type: multipart/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 <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=1 <http://www.amexmail.com/?A=1>

-- 
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

Received on Fri Aug 11 2000 - 15:08:19 CDT