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里运行下，看看有米有错。