Hi Everyone,



I love query auditing, it can really show exactly which query - or
sequence of queries - is producing errors!



And in this case we see this little beauty:

drop table a_table;

create table a_table(...sundry column definitions...);

prepare statement select count(*) from a_table;

drop table a_table; /* Whoops! */

open cursor using the prepared statement;



Now obviously the open cursor has to produce an error as the drop has
butchered the prepared statement.



I just wish it was slightly more informative than...

E_SC0207_UNEXPECTED_ERROR Facility returned an undocumented error.

ULE_FORMAT: Couldn't look up message 50903 (reason: ER error 10903)

E_CL0903_ER_BADPARAM    Bad parameter

E_SC0215_PSF_ERROR    Error returned by PSF.



These errors are produced on everything from II2.6 to Inges2006rls2.



After I finish humiliating the programmer, I suppose I should report it
as a bug of some type. Although as far as I'm concerned the bug isn't
the drop table being permitted - that's an application bug, I'm thinking
a more informative message would be desireable.



Whats your opinion?



Martin Bowes