Oracle Insert Question

[CFProgrammer]

I am trying to do a bulk copy from one datasource (Access) to another (Oracle). I know in sql server you can just separate each new inserts with a ";". But I keep getting errors in Oracle, Why?

 

[sem]

Try to enclose your code in
begin ... end; Regards, Dima

 

[Turkbear]

Hi, How are you trying such a copy?

The method I use is to export the data from Access to Oracle using ODBC ( File..Export..etc from within Access)- What tool or code are you using?

 

[CFProgrammer]

Via the web with Coldfusion. Make a call from the access DSN to the Oracle DSN. Insert the results to the Oracle DSN. Thanks...