Re: INSERT INTO and LONG columns

What you could do is create following script

Declare Cursor C_MY_TABLE IS

    SELECT
    FROM My_Table
    WHERE column_b = 1 ;

BEGIN FOR r_my_table IN c_my_table LOOP

    INSERT INTO my_table

        (column_a, column_b, column_c, column_d)     VALUES
        (r_my_table.Column_a, r_my_table.Column_b, r_my_table.Column_c, r_my_table.Column_d);

END LOOP; END; Rod Gustavson wrote in message <34D87A9B.F7EF639C_at_yale.edu>...
>Does anyone have a suggestion on how to accomplish the following?
>
>I am trying to copy all the rows from a table to itself, but with one
>value changed. One of the columns is of type LONG, so INSERT INTO
>returns error ORA-00997, Illegal use of LONG datatype.
>
>Example:
>column_a, column_b, and column_c are numbers, column_d is a LONG.
>
>INSERT INTO my_table
> SELECT column_a,
> 2,
> column_c,
> column_d
> FROM my_table
> WHERE column_b = 1
>
>If column_d is not a long, the code works.
>
>Any suggestions on how I can accomplish this?
>
>Thanks.
>
>_______________________
>
>Rod Gustavson
>rod.gustavson_at_yale.edu
Received on Mon Feb 09 1998 - 00:00:00 CST