请教一个问题,但我在C#里运行这段代码时,捕捉到错误信息:
“ORA-00911,invalid character”,
请帮我看看,谢谢!!!
急,急,急!! 代码:
strSql = "drop table T_ME_TimeAvgData" ;
strSql += ";drop table T_ME_TimeData" ;
strSql += ";drop sequence TimeDataSeq" ;
strSql += ";drop sequence AvgTimeDataSeq" ;
OleDbCommand dsCommand = new OleDbCommand();
dsCommand.CommandText = strSql ;
dsCommand.CommandType = CommandType.Text;
dsCommand.Connection = IDGConfiguration.ConnectOracleDB();
dsCommand.ExecuteNonQuery(); 看过以前单个语句产生这个错误的帖子,知道语句后面多了个冒号,不知道多个语句的应该怎么改,谢谢
“ORA-00911,invalid character”,
请帮我看看,谢谢!!!
急,急,急!! 代码:
strSql = "drop table T_ME_TimeAvgData" ;
strSql += ";drop table T_ME_TimeData" ;
strSql += ";drop sequence TimeDataSeq" ;
strSql += ";drop sequence AvgTimeDataSeq" ;
OleDbCommand dsCommand = new OleDbCommand();
dsCommand.CommandText = strSql ;
dsCommand.CommandType = CommandType.Text;
dsCommand.Connection = IDGConfiguration.ConnectOracleDB();
dsCommand.ExecuteNonQuery(); 看过以前单个语句产生这个错误的帖子,知道语句后面多了个冒号,不知道多个语句的应该怎么改,谢谢
SQL> begin
2 drop table emp;
3 drop table dept;
4 end;
5 /
drop table emp;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 1 列:
PLS-00103: 出现符号 "DROP"在需要下列之一时:
begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
SQL> begin
2 execute immediate 'drop table emp';
3 execute immediate 'drop table dept';
4 end;
5 /PL/SQL 过程已成功完成。