Manish Lal Joshi wrote:

...snip...

> Now after i created the external table,
> i queried the table like select col1,col2 from ext_table
> while(reader.read())
> {
> (a) getvalues
> (b) typecast it
> (c) insert into my real table.
> }
>

Here is where you have made a mistake...

Use the server to do the work.

Use a single statement to insert all rows from your external table,
something like:

insert into Table (ColumnA, ColumnB, ColumnC) select ColumnA, ColumnB,
ColumnC from ExternalTable

see you !


--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br