首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

ORA-01747: 无效的用户.表.列

2014-01-28 
我们的开发环境是 2005.NET 数据库是10g ~~ 程序在我们的机器上,和发布到虚拟目录上跑是一点问题都没有。 只

我们的开发环境是 2005.NET 数据库是10g ~~
程序在我们的机器上,和发布到虚拟目录上跑是一点问题都没有。

只要一到客户的服务器上就会出一个错误:
未指定的错误
ORA-01747: 无效的用户.表.列,表.列,或列规格~~

客户的服务器数据库是9i~~

我查看了配置完全都没问题~
数据库表也都对过了。也没问题。

我把我们这里生成的SQL语句发给客户的技术 让他们用PLUS执行。
都是没问题的。但是只要一到程序里就报刚刚那个错误。
我去网上查了。都是说是什么关键字当成字段的问题。
我们的字段都不是关键字啊。我实在是没办法了。。


SQL语句可能是这样子的:

update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =8086and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '

update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =8086 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '

update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =8088and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '

update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =8088 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '

update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =86202and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '

update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =86202 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '

update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =89032and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '

update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =89032 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '

update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =89176and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '         

热点排行