Re: help with simple insert

You can try sqlloader to load the data from text file to a oracle table.

Or, if you know perl, you can write your own perl script to load data into oracle table.

Hope this helps.

Guang

In article <F4py5.2653$b6.182304_at_carnaval.risq.qc.ca>,   "jman" <pumulo.sikaneta_at_mcgill.ca> wrote:
> I made a typo. The oracle field I am trying to populate has type
> varchar2(1000). It seems that the problem is with using SQL *Plus and
 the
> cause is that the SQL commands you can perform using the program have
 a
> limited length. At the cut-off point it simply ignores the rest of the
> command. I have decided to create an ODBC data source and perform the
> updates from anther program.
>
> If there is a better way I would be very eager to find it.
>
> "Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message
> news:39C8414D.C4BF0546_at_edcmail.cr.usgs.gov...
> > What error are you getting? How do you plan on squeezing a 500
 character
> > field into a 100 character field? Did I miss something else?
> >
> > HTH,
> > Brian
> >
> >
> > jman wrote:
> > >
> > > Hi I am trying to transfer data from an access database into an
 Oracle
> > > database. I have a text field with 500 characters maximum per
 record. I
 have
> > > a varchar2(100) field in the oracle database that will not accept
 these
> > > values. Is there something I need to do? I am using Ofice 2000 and
 Oracle 8
> > > Personal edition on Windows 2000.
> > >
> > > Thanks
> >
> > --
> > ========================================
> > Brian Peasland
> > Raytheons Systems at
> > USGS EROS Data Center
> > These opinions are my own and do not
> > necessarily reflect the opinions of my
> > company!
> > ========================================
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 21 2000 - 00:00:00 CDT