title: PL/SQL Concatenation
body: <p>i have a procedure that have in entry two parameters 
  CREATE_PARTITION( yearSource IN VARCHAR2 , yearDestination IN VARCHAR2 )</p>
  
  <p>when i want to insert the yearSource concatenated with another string , nothing is inserted in the table </p>
  
  <p>i declare the variable yearAA which take the yearSource and i concatenate it with a 'AA'</p>
  
  <p><strong>yearAA varchar2(30) := yearSource||'AA';</strong></p>
  
  <p>to insert it i use : </p>
  
  <p><strong>execute immediate ' INSERT INTO MOUADTEST2018 VALUES('||yearAA||')';</strong></p>
  
  <p>result : Nothing inserted 
  and it shows this message  <strong>ORA-00984: column not allowed here</strong> </p>