ORA-00984 :Column Not Allowed Here

[thebull1]

Hi All?

I am tryingto create a new table with the following strucure and getting the error mentioned. Please assist.

Column Name Null? Type Default Value
-----------------------------------------------------------
bu_segment1 Varchar2(25)
cc_segment2 Varchar2(25)
account_segment3 Varchar2(25)
project_segment4 Varchar2(25) 00000 spare1_segment5 Varchar2(25) 000000
spare1_segment6 Varchar2(25) 000000
status NOT NULL Varchar2(50) NEW
set_of_books_id NOT NULLNumber(15) 1
user_je_source_name NOT NULL Varchar2(25) SPMS
user_je_category_name NOT NULL Varchar2(25) INVENTORY
accounting_date NOT NULL Date
currency_code NOT NULL Varchar2(15) ZMK
date_created NOT NULL Date
created_by NOT NULL Number(15) 1
actual_flag NOT NULL Varchar2(1) A
entered_dr Number
entered_cr Number
group_id NOT NULL Number(15)
context2 Varchar2(150) NO
reference1 Varchar2(100)
reference2 Varchar2(100)
reference4 Varchar2(100)
reference5 Varchar2(100)

 

[dsanchez2]

Show us your CREATE statement.

 

[BJCooperIT]

Obviously you have created the table if you can DESCRIBE it as shown. What else does your script do?

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant/Custom Forms & PL/SQL - Oracle 8i & 9i - Windows 2000