The ParamByName('FIELDNAME').AsString with an design time value has problems with set a new string on it. It seams that the new string is cut at the length of the old string.
If i set value size at design time (doubleclick smartquery->params->string param->size) to larger number then the new value, it runs without problems.
At the moment i use newest 6.70 ODAC. But version 6.50 the Bug is already there.
Greetings Oliver
OraSmartQuery and ParamByName with String
This is not a bug. If the Size property is set to 0, ODAC sends full string. If the Size property is set to a value larger than 0, ODAC truncates string to that size.
Note that when you set parameter value in design-time editor, the Size property is set automatically. Then you need to change it to a value that is large enough or zero.
Note that when you set parameter value in design-time editor, the Size property is set automatically. Then you need to change it to a value that is large enough or zero.