ORA-00984: column not allowed here

[stecal]

Do you understand the usage difference between single quotation and double quotation marks in SQL?

[PinkRoses]

Thanks a lot for your time and sugessions.
Now I got the solution of my problem, Here is shell script part of code change

Code:
DATE_FORMAT="YYYYMMDD"
DATE_FORMAT=`echo "'"$DATE_FORMAT"'"`

EMPNAME=`echo "'"$EMPNAME"'"`
EMPID=`echo "'"$EMPID"'"`
DATEGEN=`echo "'"$DATEGEN"'"`
Using above syntax I am able to insert records into my table as,

Code:
INSERT INTO TBL1(EMPNAME,EMPID,EMPBDATE) VALUES($EMPNAME,$EMPID,TO_DATE($DATEGEN,$DATEFORMAT));