这条语句在PL/SQL里可以执行为什么我放在TQUERY里就不能执行了:
begin
execute dbms_logmnr_d.build(dictionary_filename='YeHe.ora',dictionary_location='E:\YeHe');
end;
begin
execute dbms_logmnr_d.build(dictionary_filename='YeHe.ora',dictionary_location='E:\YeHe');
end;
调试欢乐多
qry.sql.text:='execute dbms_logmnr_d.build(dictionary_filename='+quotedstr(YeHe.ora)+',dictionary_location='+quotedstr(E:\YeHe));
qry.close;
qry.sql.text :='execute dbms_logmnr_d.build (dictionary_filename=''YeHe.ora'',dictionary_location=''E:\YeHe''';
qry.open;
query里面要写sql语句,格式就是上面的。
格式:查询
adoquery1.close;
adoquery1.sql.text:='select * from tablename';
adoqyery1.open;
修改,删除,添加
adoquery1.close;
adoquery1.sql.text:='update tablename set field=***';
adoqyery1.execsql;
qry.sql.text:='execute dbms_logmnr_d.build(dictionary_filename='+quotedstr('YeHe.ora')+',dictionary_location='+quotedstr('E:\YeHe'));