[Phil Gibbs]

Trying to create a table for Oracle 10 I get an error in the generated DDL. The Oracle error is ORA-00907 which says that a right-paren is missing. Unfortunately, a right-paren is not missing.
Here’s the generated DDL:
create table WINRLS.CUST_PRICE_ADJ(AP_NUM VARCHAR2(16) NOT NULL UNIQUE, ADJ_NUM VARCHAR2(16) NOT NULL UNIQUE, ADJ_NAME VARCHAR2(32) NOT NULL, ADJ_TYPE VARCHAR2(6) NOT NULL, ADJ_VALUE FLOAT(9,4) NOT NULL,
constraint AP_NUM PRIMARY KEY(AP_NUM,ADJ_NUM))

This is Oracle version 10, MyEclipse 5.5.1 and Eclipse 3.2.

[Loyal Water]

Everything looks fine to me. Are you able to run this query outside MyEclipse ?

[Phil Gibbs]

thx for your reply. Yes it was ok and now works fine.

[Loyal Water]

Glad its working now. Thanks for letting me know.

[Author]

Posts