Need some help/Tips [message #396127] |
Sat, 04 April 2009 01:47 |
|
Hi,
I have got a ORA-00984 Error problem, where i have tried my level best to solved it out and unfortunately i failed to come up with a solution. But for deploying the overall project this was the last module i need to work on. So please help me. There is three table i worked with, where the value of two tables with stored in the 3rd table. For your better understanding i am providing you the table structure:
SQL> desc product_target;
Name Null? Type
------------------------------- -------- ----
PRODUCT_CODE NOT NULL VARCHAR2(4)
YEAR_NO NOT NULL NUMBER(4)
MONTH_ID NOT NULL NUMBER(2)
TARGET_QTY NUMBER(6)
PRODUCT_NAME VARCHAR2(50)
SQL> desc dealer_contribution;
Name Null? Type
------------------------------- -------- ----
DISTRIBUTOR_CODE VARCHAR2(4)
CONTRIBUTION NUMBER(10,3)
PRODUCT_CODE VARCHAR2(4)
PRODUCT_NAME VARCHAR2(50)
INV_RATE NUMBER(10,2)
PACK_SIZE NUMBER(10,2)
YEAR_NO NUMBER(4)
SQL> desc dealer_target_tbl;
Name Null? Type
------------------------------- -------- ----
DISTRIBUTOR_CODE NOT NULL VARCHAR2(4)
DISTRIBUTOR_NAME VARCHAR2(50)
DISTRIBUTOR_GL_CODE VARCHAR2(17)
TARGET_YEAR NOT NULL NUMBER(4)
MONTH_ID NOT NULL NUMBER(2)
PRODUCT_CODE NOT NULL VARCHAR2(4)
TARGETED_QTY_MONTHLY NUMBER(14,2)
TARGETED_AMT_MONTHLY NUMBER(14,2)
REMARKS VARCHAR2(100)
USER_ID VARCHAR2(10)
PRODUCT_NAME VARCHAR2(50)
GL_PRODUCT_CODE VARCHAR2(17)
INV_RATE NUMBER(22,2)
SQL>
Regards,
Mahatab Masud
|
|
|
Re: Need some help/Tips [message #396228 is a reply to message #396127] |
Sun, 05 April 2009 05:19 |
ora_baby
Messages: 89 Registered: May 2008
|
Member |
|
|
ORA-00984: column not allowed here
Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.
Action: Check the syntax of the statement and use column names only where appropriate.
|
|
|
|
|