I've run into a strange problem. I have a query that ran successfully dozens of times:
select * from kmby_data where index = (select index from kmby_log where seq = (select max(seq) from kmby_log));
One of my coworkers recreated the kmby_data table (identical structure) & now I get the following error on the query:
ERROR: ExecReScanSetParamPlan: extParam list of plan is NULL
I've never seen an error even remotely like this & have no idea what it means. The two halves of the query both run successfully. I only get the error on the full query.
Email replies are appreciated. I only subscribe to the digest.
Thanks
bg