On Jul 18, 2008, at 10:54 AM, Martin Bowes wrote:
> 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 undo***ented 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.
>
Whinge, whinge, whinge. Some people are just never satisfied.
I suppose you want something like "prepared statement was invalidated by
DDL".
I have a quarter here that says this one is going to turn out to be
bizarrely more complicated to fix than any sane person might imagine.
I haven't looked at the code at all, I'm just guessing wildly ...
Karl
