you should close the statment for yourself
Vladimir M. Zakharychev wrote:
> <g_chime_at_yahoo.com> wrote in message news:1144262718.254813.97660_at_t31g2000cwb.googlegroups.com...
>
> > Open cursurs setting in init.ora: 300
>
> Well, this clicks with the amount of rows you can insert
> before you hit ORA-1000, isn't it? :)
>
> Make sure you are closing your explicit cursors when
> they are no longer needed. Actually you need only one
> cursor for the insert statement. You simply bind different
> values to the statement and re-execute it.
> A snippet of your code that instantiates the statement and
> executes it would be helpful to diagnose the issue further.
>
> And a side note: there is SQL*Loader tool in Oracle
> and there are external tables, both there for ETL
> purposes. External table is a link to an external file
> plus definition of data layout in that file in SQL*Loader
> format. When you select from such table, Oracle
> internally parses the file according to the definition
> (practically same thing you do in your application.)
> You can
>
> INSERT INTO target SELECT * FROM external_table
>
> and you get your file parsed and loaded in one run,
> with bad rows (those Oracle couldn't parse) logged
> in another file you specify. Note that the source
> file should be on the server and accessible to the
> Oracle instance for this.
> SQL*Loader is client-side tool, and it does essentially
> the same job, just on the client. Its control file format
> and operation is described in detail in Oracle Utilities
> manual.
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Fri Apr 07 2006 - 02:34:04 CDT
