Bug - Bind variables not recognised in model clause - Toad 12.10.0.30

Toad for Oracle
1

It appears there is a bug in the model clause where bind variables are not picked up for value entry at execution time. See the following simple example - if run in Toad, the window pops up to accept the bind variable value input, however the bind variable isn’t listed.

  Select *
From dual
Model Dimension by (dummy d)
Measures ('A' v)
Rules (
v['X'] = :val
);
2

Yes, it is a bug. I logged it. Thanks for your help.

3

Looks like it was also raised back in 2011 too.

http://www.toadworld.com/products/toad-for-oracle/f/10/t/10335

I appreciate the Model clause isn’t used all that often, however it is a 10g feature at the end of the day so it’s not like it’s something new.

4

Thanks, the issue has been logged. It fell through the cracks in 2011 and likely never made its way into our bug tracking system.

5

This is fixed for Toad 12.12.

Michael