Re: adding records into an oracle table

From: Richard D Holowczak <holowcza_at_andromeda.rutgers.edu>
Date: 2 Feb 1995 21:17:27 -0500
Message-ID: <3gs3nn$lh_at_andromeda.rutgers.edu>


Matthew Rowe <rtcs-mr_at_bnc.com.au> writes:

>Hi,
> I am writing a database package that will transfer any dbf
>file to an oracle7 database. New tables with the same fields etc
>as the source are created in oracle, however I want to use the
>ADDNEW method to add records to the destination table. The ADDNEW
>method won't work.

  If I recall correctly, the destination table needs to have   a unique INDEX on it in order to use this method to insert   new rows.   

  Hope that helps.

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Fri Feb 03 1995 - 03:17:27 CET

Original text of this message