Multi-line comments on Power Designer 15 are not generated in Oracle Database

[Former Member]

Hi

I have created a database design with multi-line comments. When I generate the sql file and run it in the Oracle Database I get an error generating the comments because of the new line.

Regards,

Néstor

[former_member185317]

Hi Nestor,

Being that v15 is a few years old and end of maintenance, all I could do was test it in the latest release 16.5 SP05 PL02. I put a multi-line comment in the Comment attribute for a Table and it runs okay. Here is my preview:

create table TABLE_1;

comment on table TABLE_1 is
'abcdefg
highkcl
sfdfgfgkjf;jghfskj
adsfjkgl;sfkjlsdf';

Maybe you can cut and paste and try? Or try to upgrade to the latest PowerDesigner version and test?

HTH,

-Matt C.