Re: Can you set commit level inside a insert/select?

[Michael Lee <homestoremike@YAHOO.COM>]

Hi,
Thanks for all the people who responded.  I must
reinterate that I am doing an Insert/Select within ONE
begin-SQL.  I cannot set up a counter to count up to
1000 rows inserted, then reset the counter back to
zero.  That's why I said below that I "usually" do
that, but in this case, I cannot.

BTW, I am running Oracle 8.1.6.

Has anyone done this before?

An example of my code is below in my older e-mail.
Any response would be greatly appreciated!

Thanks in advance,

Michael

--- Michael Lee <homestoremike@YAHOO.COM> wrote:
> Hi,
> Can you set the commit level (i.e. set commit 1000;)
> inside an insert/select statement?
>
> For example:
>
> begin-SQL
>
> INSERT INTO <TABLE2>
> SELECT FROM <TABLE1>
>
> end-SQL
>
> Usually, I have a two separate procedures, one to
> select and one to insert.  And I keep track of the
> number of rows inserted until it reaches lets say
> 1000
> rows.  Then I have an if-statement to check to see
> if
> it's time to commit, and then reset the counter.
>
> However, how would you do manage to set the commit
> level for an insert/select?
>
> Thanks in advance,
>
> Mike
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com