微软报表 连接orcal数据库问题
SELECT F_ID, F_STAFFNUMBER, F_STAFFNAME, F_STAFFNAMEPINYIN, F_COMPID, 
  F_SEX, F_NATION, F_HOMEPLACE, F_BIRTHDAY, F_MARRIAGE, F_POLICY, 
  F_FAMILYSTATUS, F_CULTURECLASS, F_COURSE, F_COLLEGE, F_GRADUATETIME, 
  F_PROFESSION, F_FOREIGN, F_COUNTRYYEAR, F_COUNTRYMONTH, 
  F_SOLDIERYEAR, F_SOLDIERMONTH, F_CREDITID, F_SECURITYID, F_HOSPITALID, 
  F_PUBLICFUNDID, F_UNEMPLOYID, F_DISABLEDCARD, F_VEHICLEID, 
  F_VEHICLETIME, F_TELEPHONE, F_POSTID, F_CELLPHONE, F_DOCUMENTPLACE, 
  F_STREET, F_FOREIGNFAMILY, F_INSYSTIME, F_BEGINWORKTIME, 
  F_INCOMPTIME, F_POLICYCHECK, F_HEALTHYCARD, F_DRIVECARD, 
  F_PROFESSIONCARD, F_STUDYCARD, F_EMPLOYCARD, F_BUSINESSCARD, 
  F_PHOTO, F_FLAG
FROM V_STAFFINFORMATION_JB
WHERE (F_STAFFNAME=@prt1)

提示ORA-00936: 缺失表达式
@prt1是一个参数
给我大虾，这时为什么啊？应该怎么写啊

------解决方案--------------------
估计sql语句有问题，给WHERE F_STAFFNAME=一个具体的值，看看能否运行。

也可以把sql直接在Oracle里运行下，看看有米有错。