Re: INSERTing string containing character '&'

I tried the various defines & sets with various degrees of lack of luck. Your PL/SQL script worked like a charm, and imported about 136000 records in less than 30 sec.

I still have some things I don't fully understand. Apparently, the drive with the disk file must be local to the server. I was unable to get UTL_FILE to read from the client disk at all. Am I correct in assuming that the file must reside on the server?

In article <7hnrdu$of5$1_at_front1.grolier.fr>,   "Arlette BROSSARD" <abray_at_club-internet.fr> wrote:
> '&' is the default character for DEFINE (to use parameters in SQL+)
> You can change it for a while in SQL+, so you can use another
character that
> you're sure is not
> in your file (µ for example).
> SET DEFINE µ
> INSERT INTO names VALUES ( '00001', 'Bartles&James' );
> SET DEFINE & (if necessary)
>
> If the names are in a file, you can read this file in a PL/SQL block
and
> insert all the names in a table
> with no trouble. For that you can use the build-in package UTL_FILE.
>
> An example for Windows :
> DECLARE
> sname VARCHAR2(45);
> file UTL_FILE.FILE_TYPE;
> BEGIN

[snip]
--
Replies send to this email address are automatically discarded. To reply, please post in this newsgroup, or email to harkness at skeptics dot org.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 17 1999 - 18:49:36 CDT