Home » Developer & Programmer » Forms » Need some help/Tips (Oracle9i, Developer 6i, WinXp)
Need some help/Tips [message #396127] Sat, 04 April 2009 01:47 Go to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

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 Go to previous messageGo to next message
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. 
Re: Need some help/Tips [message #396231 is a reply to message #396127] Sun, 05 April 2009 05:33 Go to previous messageGo to next message
haider_1pk
Messages: 85
Registered: March 2009
Location: PAKISTAN
Member
DEAR FRIEND,
HOW RU . I HOPE U WILL BE FINE.
PLEASE GIVE YOUR CONNTACT NUMBER .
HAIDER
Re: Need some help/Tips [message #396232 is a reply to message #396231] Sun, 05 April 2009 05:38 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Don't post in UPPER case, it is hear as shouting.
Please read OraFAQ Forum Guide.

For these kind of info, you can use PM instead.

By
Vamsi
Previous Topic: Multiple row problem
Next Topic: Commit Statement
Goto Forum:
  


Current Time: Sat Dec 10 05:01:26 CST 2016

Total time taken to generate the page: 0.08033 seconds