title: DatabaseError: ORA-01036: illegal variable name/number
body: <p>I need to substitute the following values into select query. but i got the error as i mentioned below </p>
  
  <pre><code>self.jobNo = J-12060
  qcActivity = C173
  self.wrkArea = 1666339
  
  cursor.execute("""SELECT A.MARKERID, D.COMMENTS,A.STATUS,A.X1,A.Y1,A.X2,A.Y2,C.ERRGROUP,C.ERRDESC,c.category
             FROM MDP_ERR_MASTER A,(SELECT MARKERID, MAX(RECNO) maxRECNO FROM MDP_ERR_MASTER where project_code = ':jobno'
             and errorcode like ':jobno_:qcActivity%' AND WORKAREA LIKE ':workarea%'
             GROUP BY MARKERID) B,MDP_ERR_CONFIG C,(SELECT MARKERID, COMMENTS FROM MDP_ERR_MASTER WHERE PROJECT_CODE = ':jobno'
             AND RECNO = 1 AND errorcode like ':jobno_:qcActivity%' AND WORKAREA LIKE ':workarea%') D
             WHERE(A.MARKERID = B.MARKERID And A.RECNO = B.maxRECNO And A.Markerid = D.MARKERID)AND A.PROJECT_CODE = ':jobno'
             AND A.ERRORCODE LIKE ':jobno_:qcActivity%'  AND A.WORKAREA LIKE ':workarea%' AND A.ERRORCODE = C.ERRCODE""",
             {"jobno" : str(self.jobNo),
              "qcActivity" : str(qcActivity),
              "workarea" : str(self.wrkArea)
              })
  
  
  Traceback (most recent call last):
  File "D:\work\venkat\QGIS\Tools\GlobalErrorMarker\globalerrormarker.py", line 272, in      btnDownloadError_Clicked
  "workarea" : str(self.wrkArea)
  DatabaseError: ORA-01036: illegal variable name/number
  </code></pre>