Delimiter is sent to the database

[GoogleCodeExporter]

With the following patch script:

--* DELIMITER IS ISOLATED ^

BEGIN
    FOR T IN ( SELECT TABLE_NAME, COLUMN_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'WOZ_ENDDATE' ) LOOP
        EXECUTE IMMEDIATE 'ALTER TABLE ' || T.TABLE_NAME || ' MODIFY ' || T.COLUMN_NAME || ' NULL';
    END LOOP;
END;
^

You get the following error:

BUILD FAILED
D:\PROJECTS\TAXI\taxi-parent\taxi-database\build.xml:26: 65000: ORA-06550: 
Regel 6, kolom 1:
PLS-00103: Symbool "^" aangetroffen Symbool "^" werd genegeerd.
.

While executing line 15903: BEGIN
        FOR T IN ( SELECT TABLE_NAME, COLUMN_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'WOZ_ENDDATE' ) LOOP
                EXECUTE IMMEDIATE 'ALTER TABLE ' || T.TABLE_NAME || ' MODIFY ' || T.COLUMN_NAME || ' NULL';
        END LOOP;
END;
^

Which seems to indicate that the delimiter is sent to the database.

Original issue reported on code.google.com by rene.de....@gmail.com on 14 Jun 2010 at 4:03

[GoogleCodeExporter]

Seemed to be caused by ^ which is a special character in regular expressions.
Need to test again.

Original comment by rene.de....@gmail.com on 14 Jun 2010 at 8:26

[GoogleCodeExporter]

Fixed by rev 442.

Original comment by rene.de....@gmail.com on 2 Oct 2010 at 2:08

• Changed state: Fixed