Claus Pedersen
Member³
I have created a database link. The link is created via an ODBC definition in Windows.
When I create the database link and name it TEST, Oracle adds the domain name to the link name, so it is now called TEST.MY-DOMAIN.COM.
Note that there is now a hyphen in the database link name.
When I edit the database link in the editor, the changes fail with error "ORA-00993: SQL command not properly ended", because PLD forgets to add double quotes to the database link name (and hyphen is not allowed in a non-quoted Oracle name).
To the developers at Allroundautomations: please test all browser functions and the editors for different objects to make sure that they can handle object names created with double quotes (either by the user or by Oracle).
When I create the database link and name it TEST, Oracle adds the domain name to the link name, so it is now called TEST.MY-DOMAIN.COM.
Note that there is now a hyphen in the database link name.
When I edit the database link in the editor, the changes fail with error "ORA-00993: SQL command not properly ended", because PLD forgets to add double quotes to the database link name (and hyphen is not allowed in a non-quoted Oracle name).
To the developers at Allroundautomations: please test all browser functions and the editors for different objects to make sure that they can handle object names created with double quotes (either by the user or by Oracle).
