日期:2014-05-17  浏览次数:20965 次

数据建立出错的问题
各位好,我使用的是C#的程序,ORACLE11g R2的数据库,因为以前建立了一笔数据,因有错误又将其删除了,并已经删除了与其有关联的所有数据,包括有约束等的,全部删除了,但是现在在建立数据的时候直接就出现一错误提示,具体提示如下,请各位帮忙看看,问题是出在了那里,谢谢!

could not execute query
[ SELECT this_.SYSID as SYSID66_2_, this_.VERSION as VERSION66_2_, this_.NAME as NAME66_2_, this_.DESCRIPTION as DESCRIPT4_66_2_, this_.CATEGORY as CATEGORY66_2_, this_.MEASUREMENTTYPE as MEASUREM6_66_2_, this_.DATATYPE as DATATYPE66_2_, this_.UNIT as UNIT66_2_, this_.AUTOEXCLUDE as AUTOEXCL9_66_2_, this_.UPPERSCREENINGLIMIT as UPPERSC10_66_2_, this_.LOWERSCREENINGLIMIT as LOWERSC11_66_2_, this_.UPPERSPECLIMIT as UPPERSP12_66_2_, this_.LOWERSPECLIMIT as LOWERSP13_66_2_, this_.TARGET as TARGET66_2_, edcsamplin2_.SYSID as SYSID132_0_, edcsamplin2_.VERSION as VERSION132_0_, edcsamplin2_.DESCRIPTION as DESCRIPT3_132_0_, edcsamplin2_.ISREQUIRED as ISREQUIRED132_0_, edcsamplin2_.NUMBEROFUNITS as NUMBEROF5_132_0_, edcsamplin2_.NUMBEROFSITES as NUMBEROF6_132_0_, edcsamplin2_.NUMBEROFSAMPLES as NUMBEROF7_132_0_, edcsamplin2_.MEASUREMENTSPEC as MEASUREM8_132_0_, edcstatist3_.SYSID as SYSID51_1_, edcstatist3_.VERSION as VERSION51_1_, edcstatist3_.DESCRIPTION as DESCRIPT3_51_1_, edcstatist3_.NEEDMIN as NEEDMIN51_1_, edcstatist3_.NEEDMAX as NEEDMAX51_1_, edcstatist3_.NEEDAVG as NEEDAVG51_1_, edcstatist3_.NEEDSTD as NEEDSTD51_1_, edcstatist3_.MEASUREMENTSPEC as MEASUREM8_51_1_ FROM MES_MEASUREMENTSPEC this_ left outer join MES_SAMPLINGPLAN edcsamplin2_ on this_.SYSID=edcsamplin2_.MEASUREMENTSPEC left outer join MES_STATISTICPLAN edcstatist3_ on this_.SYSID=edcstatist3_.MEASUREMENTSPEC WHERE this_.NAME = :p0 ]
Positional parameters: #0>a
[SQL: SELECT this_.SYSID as SYSID66_2_, this_.VERSION as VERSION66_2_, this_.NAME as NAME66_2_, this_.DESCRIPTION as DESCRIPT4_66_2_, this_.CATEGORY as CATEGORY66_2_, this_.MEASUREMENTTYPE as MEASUREM6_66_2_, this_.DATATYPE as DATATYPE66_2_, this_.UNIT as UNIT66_2_, this_.AUTOEXCLUDE as AUTOEXCL9_66_2_, this_.UPPERSCREENINGLIMIT as UPPERSC10_66_2_, this_.LOWERSCREENINGLIMIT as LOWERSC11_66_2_, this_.UPPERSPECLIMIT as UPPERSP12_66_2_, this_.LOWERSPECLIMIT as LOWERSP13_66_2_, this_.TARGET as TARGET66_2_, edcsamplin2_.SYSID as SYSID132_0_, edcsamplin2_.VERSION as VERSION132_0_, edcsamplin2_.DESCRIPTION as DESCRIPT3_132_0_, edcsamplin2_.ISREQUIRED as ISREQUIRED132_0_, edcsamplin2_.NUMBEROFUNITS as NUMBEROF5_132_0_, edcsamplin2_.NUMBEROFSITES as NUMBEROF6_132_0_, edcsamplin2_.NUMBEROFSAMPLES as NUMBEROF7_132_0_, edcsamplin2_.MEASUREMENTSPEC as MEASUREM8_132_0_, edcstatist3_.SYSID as SYSID51_1_, edcstatist3_.VERSION as VERSION51_1_, edcstatist3_.DESCRIPTION as DESCRIPT3_51_1_, edcstatist3_.NEEDMIN as NEEDMIN51_1_, edcstatist3_.NEEDMAX as NEEDMAX51_1_, edcstatist3_.NEEDAVG as NEEDAVG51_1_, edcstatist3_.NEEDSTD as NEEDSTD51_1_, edcstatist3_.MEASUREMENTSPEC as MEASUREM8_51_1_ FROM MES_MEASUREMENTSPEC this_ left outer join MES_SAMPLINGPLAN edcsamplin2_ on this_.SYSID=edcsamplin2_.MEASUREMENTSPEC left outer join MES_STATISTICPLAN edcstatist3_ on this_.SYSID=edcstatist3_.MEASUREMENTSPEC WHERE this_.NAME = :p0]

------解决方案--------------------
SQL code
SELECT this_.SYSID as SYSID66_2_, this_.VERSION as VERSION66_2_, this_.NAME as NAME66_2_, this_.DESCRIPTION as DESCRIPT4_66_2_, this_.CATEGORY as CATEGORY66_2_, this_.MEASUREMENTTYPE as MEASUREM6_66_2_, this_.DATATYPE as DATATYPE66_2_, this_.UNIT as UNIT66_2_, this_.AUTOEXCLUDE as AUTOEXCL9_66_2_, this_.UPPERSCREENINGLIMIT as UPPERSC10_66_2_, this_.LOWERSCREENINGLIMIT as LOWERSC11_66_2_, this_.UPPERSPECLIMIT as UPPERSP12_66_2_, this_.LOWERSPECLIMIT as LOWERSP13_66_2_, this_.TARGET as TARGET66_2_, edcsamplin2_.SYSID as SYSID132_0_, edcsamplin2_.VERSION as VERSION132_0_, edcsamplin2_.DESCRIPTION as DESCRIPT3_132_0_, edcsamplin2_.ISREQUIRED as ISREQUIRED132_0_, edcsamplin2_.NUMBEROFUNITS as NUMBEROF5_132_0_, edcsamplin2_.NUMBEROFSITES as NUMBEROF6_132_0_, edcsamplin2_.NUMBEROFSAMPLES as NUMBEROF7_132_0_, edcsamplin2