Re: CASE Dictionary DDL Problems

In <412k61$dp8_at_spk41.usace.mil> c0imijka_at_mrd61.mrd-wc.usace.army.mil (James K. Anderson) writes:
>
>We are using CASE Dictionary 5.0. When I run the DDL script generated
 by Dictionary, I get errors messages
>when DDL commands creating Primary Keys and Foreign Keys are executed.
 The errors say that the command
>is missing the right parenthesis. An example is:
>
>ALTER TABLE ALTER_SOURCES ADD (
> PRIMARY KEY (CODE)
> CONSTRAINT ALTSRCE_PK
>)
>;
>
>When I switch the PRIMARY KEY and CONSTRAINT lines, the command works
 fine.
>
>Has anyone encountered this problem? Is there a way to modify the DDL
 generator to format the command
>correctly? I can fix the problem by manually changing switching the
 lines, but this is rather cumbersome.
>
>Thanks,
>Jim Anderson
>anderson_at_mrd.usace.army.mil

You need to SET COMPAT V6 either in the script or SQL*PLUS; you're running against a V7 database.

-JJ  

 Jeffrey Jacobs & Associates
 Oracle CASE Consulting and Training
 951-2 Old Country Road, Suite 119
 Belmont, CA 94002
 Voice: 415-571-7092
 FAX: 800-665-1379
 CompuServe: 76702,456
 Internet: jjacobs_at_well.com
 Internet: jmjacobs_at_ix.netcom.com   Received on Sat Aug 19 1995 - 00:00:00 CEST