Toad World® Forums

Suggestion for sql from run wizard.


#1

In automatic generated code from run wizard,

In exception part,we have something like that:
dbms_output.put_line(SubStr('Error ‘||TO_CHAR(SQLCODE)||’: '||SQLERRM, 1, 255));
That exeception hide real place of error in code.

In 10g we can use full 32k output with utility dbms_utility.format_error_backtrace.

Maybe could we add a option to generate sql without exception statement…

Regards


#2

Piter,
Thanks for good suggestion. We will take it as future enhancement
Rgds,
Andrew