Re: help with simple insert

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!
> ========================================
Received on Thu Sep 21 2000 - 00:00:00 CDT