客户端没执行成功的 sql 完整语句: What's the definition of 没执行成功的 sql 完整语句 ? but anyway I provide an idea .create a table log_sql ( username , execute_date , sql )
in your procedure , when exception , logging all the necessary information into this table . So in any place ( server) , you will know which sql is failed . But for doing that , you must set very good exception handling in your codeing .
in your procedure , when exception , logging all the necessary information into this table . So in any place ( server) , you will know which sql is failed . But for doing that , you must set very good exception handling in your codeing .
建立一个数据库级的触发器,当有PL/SQL错误的时候,把错误的语句插入到一个表中去。
create or replace trigger sql_error
after servererror on database
begin
insert into plsql_error
values (sys.login_user,sys.database_name,dbms_utility.format_error_stack);
希望这样有帮助。