Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [How did I lose the TRUNC() function]

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

From: Yigal Ran <>
Date: 10 Aug 00 19:42:14 EDT
Message-Id: <>

Replace "TRUNC" with "TRUNCATE".


"Koivu, Lisa" <> 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 =
> this before? FWIW, this is in a cursor.
> =

> Thanks
> =

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

> V: 954.484.3191, x174
> F: 954.484.2933 =

> C: 954.658.5849
> =

> "The information contained herein does not express the opinion or posit=
> of and cannot be attributed to or made binding upon"=

> =

Get free email and a permanent address at

 From: "Larry G. Elkins" <>  Date: Thu, 10 Aug 2000 19:11:54 -0500
 Subject: RE: Data conversion


There are numerous ways to get Notes data into an Oracle database. What route you want to take depends upon a number of factors. It has been a while since I have had to do any Notes to Oracle or vice versa type of stuff; so, some things may have changed.

You can do it directly using products such as NotesPump, or, other 3rd party products. You can write LotusScript programs to directly read the Notes data and insert into Oracle, or, you can export the data from Notes and use SQL*Loader to blow in the data. This is not an exhaustive list of the ways to accomplish this.

For example, when faced with a one time transfer, I selected the Notes View that contained the data and exported it to a flat file and used SQL*Loader to load it in. It's been a while; but, I think you could also export it out to a 1-2-3 spreadsheet, which was one easy step away from creating a csv file. At times we used the Notes ODBC driver to access the data and create a file -- maybe connecting to the Notes database from MS Acess, bringing in the data, saving off to a csv format file, and then using SQL*Loader to load the data. In one case where the transfer needed to be recurring and they didn't want to buy an additional product, I wrote a LotusScript program (various ones actually using LS:DO, or pure ODBC, or OracleLSX). Even though I wasn't a Notes programmer, through the on-line help examples and some examples at the Lotus support site, I was able to get something done in about a day (a real Notes programmer would probably have a field day laughing at my code; but, it got the job done). Considering I'm not a Notes programmer and I got in going in a day, it obviously wasn't that tough.

If this is a one time conversion of application and its data, maybe they are migrating the app to Oracle, you might just want to dump all the data to files and use SQL*Loader. With all that said, I still had to create the appropriate table(s) on the Oracle side, or, insert/update existing tables. Back when I did this 4 or 5 years ago, it wasn't like there was some tool that would automatically create the Oracle structures and migrate the data. Maybe there is now.

Anyway, I've just barely touched on the surface here. The bottom line is Received on Thu Aug 10 2000 - 18:42:14 CDT

Original text of this message