Rob_J wrote:The 'for some reason' is simple enough. When parsing out a variable name, sqlplus takes that first 'dot' as the delimiter of the name, and nothing more.
I think Mihael is right, when you have used a variable such as has been used in the original example the two dots are required for some reason.
I've had the same issue and that's how we got around it. It's the same if you just want a dot to appear, such as when creating a database link with a domain at the end and you have a variable used for the database name.