title: ORA-00984 column not allowed here
body: <p>I am getting error 
  "Execute-984 ORA-00984: column not allowed here"
  while I am inserting values in my table Registred_Customer using Pro*C</p>
  
  <p>Registred_Customer is defined as </p>
  
  <pre><code>CREATE TABLE Registred_Customer (
      Cust_id NUMBER(6) PRIMARY KEY,
      Name VARCHAR2(20) NOT NULL,
      Age NUMBER,
      Sex CHAR,
      Addr VARCHAR2(50),
      Contact NUMBER(10)
  );
  </code></pre>
  
  <p>Inserting values using a pro*c method </p>
  
  <pre><code>addCustomer(i, name,age, gender, address,contectNo);
  </code></pre>
  
  <p>in Pro*C method I use following code to insert </p>
  
  <pre><code>EXEC SQL INSERT INTO REGISTRED_CUSTOMER VALUES  
  (cust_id, cust_name, age, sex, addr,   contact);
  </code></pre>
  
  <p>here cust_name and addr are char *; and sex is char rest as int;</p>
  
  <p>It reports error while using variable but works fine using direct values
  like <code>EXEC SQL INSERT INTO REGISTRED_CUSTOMER VALUES (10, 'Pankaj', 23, 'M', 'asdfs', 45875);</code></p>
  
  <p>I tried changing few lines but in vain.</p>
  
  <p>Thanks in advance.</p>