Field names with spaces cause problems for linked fields

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create some tables containing fields whose names have spaces in them.
2. Create one or more relationships between the tables.
3. Try to add a new record to a table containing a linked field.

What is the expected output? What do you see instead?
I expected that this would work like any other linked field. However, the 
system first of all refuses to show the content of any field other than the 
primary key in the linked table drop-down list, and then starts crashing 
whenever you try to do more or less anything.

Going back to the schema designer and replacing all the spaces with underscores 
seems to have fixed the problem. I haven't yet had time to work through 
systematically and discover whether the cause is spaces in the name of the 
linked field itself, or in the table it's linking to.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by meriel.p...@gmail.com on 27 Jul 2015 at 5:03

[GoogleCodeExporter]

I'm now somewhat baffled. I returned to the tables I was working with 
yesterday, and noticed that the name of one of the fields in the linked-to 
table still contained a space. For consistency, I changed this to an 
underscore. When I tried to view the table again, the system crashed. When I 
changed it back to a space, it was fine again.

Another field in the same table did contain an underscore, and that didn't seem 
to be causing any problems - it was only when I changed the second field to 
also contain an underscore that ORDS seemed to object.

Original comment by meriel.p...@gmail.com on 29 Jul 2015 at 12:32