CF23 update 24 colon used in the dbvarname. causes error The value contains invalid characters.

Bummer to see the problem but glad to see it raised here in this new CF tracking system. It does indeed seem a failure on Adobe’s part to have considered/tested use of cfprocparam with dbvarnames as used on Oracle, which use that : prefix (as is documented in the CF docs on cfprocparam). A very unfortunate slip. Hope they’ll come out with a special hotfix that adds : to the list of allowed strings that this Sept update implemented.

For those interested, see also the bug report someone raised on this same issue that someone else had raised also earlier today in the traditional tracker.adobe.com (that system hides who the author is, so I can’t tell who it was--but the wording is different from here so I will assume it was someone else).

As the quip goes, “vote early and vote often”...or in this case, vote in both. It’s not clear who in Adobe sees which. (This one is just weeks old. Perhaps it will soon entirely replace the other. I have not heard.)

We’re running into the same problem in CF2025 Update 13 - the colon was added as an invalid character and now Oracle stored procedures cannot be run reliably. Removing the colon results in errors from the database. Was this change tested in Oracle? It really seems like it wasn’t...