Oracle Proc to SQL Reporting Services:无法识别字符集名称

   --- End of inner exception stack trace ---
w3wp!processing!8!7/27/2009-09:26:09:: e ERROR: An exception has occurred in data source 'CSUD3_RPTAPL'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'MYDATASET'. ---> System.Data.OracleClient.OracleException: ORA-06550: line 1, column 57:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

select 'test' "field1" from dual;

它会得到同样的错误。今晚,我将尝试将NLS_LANG设置回原来的值,看看这是否修复了过程——尽管这会破坏oracle的常规报告。如果有人知道发生了什么,请告诉我。

从我读到的内容来看,如果客户机上没有指定字符集,那么客户机应该使用数据库默认值。