Bugs in Quest Error Manager

I found some bugs in the Quest Error Manager (QEM).

So I changed q$error_manager package. The changes I made soo far are:



* changed register_oracle_error to only register the error (not re-raise it)
* overload of register_oracle_error to be able to get the err_instance_id_out
* l_return q$error.name%TYPE; --fds: was all_objects.object_name%TYPE;
That is because that the code below could give more than 30 char
ELSE UPPER (SUBSTR (SQLERRM (error_code_in),
INSTR (SQLERRM (error_code_in), ':') + 2))
* FUNCTION top_packprog_name
RETURN VARCHAR2 --fds was:all_objects.object_name%TYPE
That’s because the maximum size (for now) its 61 (30+1+30) and not only 30 )
* A trigger to fill the environment_info , created_on and created_by columns on the q$error_instance table

I send my q$error_manager.sql to Steven and maybe it will appear in a new version on the Framework.

Update (November 2008): All of these changes are already incorporated in the new QEM version :-)