Yup, that's a bug! Not sure how that one slipped through. Could you
confirm what version you are using (0.5/0.6/0.7)? Then let Arek/Syed
know. Arek/Syed - once you know the version, can you find
OracleDialect, and do a search-and-replace for all instances of 'add
column' to 'add'? I don't have access to CVS anymore as you know.
cheers,
Richard
2008/6/9 Renato Golin <[EMAIL PROTECTED]>:
>
> Hi,
>
> The following query is being built by MartBuilder:
>
> SQL> alter table RENATO1.C__COMMENT_BLOCK__main add column
> (COMMENT_BLOCK_count integer default 0);
>
> ERROR at line 1:
> ORA-00904: : invalid identifier ("column")
>
>
> the correct syntax (according to our Oracle) is:
>
> SQL> alter table RENATO1.C__COMMENT_BLOCK__main add (COMMENT_BLOCK_count
> integer default 0);
>
> Table altered.
>
>
> cheers,
> --renato
>
> --
> Reclaim your digital rights, eliminate DRM, learn more at
> http://www.defectivebydesign.org/what_is_drm
>
