DZone Database Zone
Too Many PreparedStatement Placeholders in Oracle JDBC
There are multiple causes of the ORA-01745 ("invalid host/bind variable name error") error when using an Oracle database. The Oracle 9i documentation on errors ORA-01500 through ORA-02098 provides more details regarding ORA-01745. It states that the "cause" is "a colon in a bind variable or INTO specification was followed by an inappropriate name, perhaps a reserved word."
It also states that the "action" is "change the variable name and retry the operation." In the same Oracle 12g documentation, however, there is no description of "cause" or "action" for ORA-01745, presumably because there are multiple causes and multiple corresponding actions associated with this message.
No comments:
Post a Comment