ORA 01745 (invalid host/bind variable name) and CURSOR_SHARING
693795Oct 29 2009 — edited Oct 30 2009For the past couple of weeks, a user has had an issue with an application in the production environment only. I've had the vendor looking at it but they were limited since it could not be reproduced in our DEV environment. I finally had some time to look into it myself and I found the problem SQL statement. The issue boils down to this, "SELECT 'N' INDICATOR FROM DUAL;" returns an ORA-01745 error. If I rename "INDICATOR" to "INDICATO" or if I add an "AS" before the alias, the query works fine. However, it would require the vendor to change the code in the application which is not likely (not for free at least). However, I also found if I change the CURSOR_SHARING from SIMILAR to EXACT, then it works. This was the reason for the difference between DEV & PRD. PRD is set to SIMILAR while DEV is set to EXACT. The prospect of setting PRD to EXACT to appealing as I'm afraid it may affect performance in other areas. But, in the end, that may be the only solution. However, I was hoping there might be some other parameter that I am not aware of that may also fix this issue. I am running 10.2.0.4. Any help would be appreciated.