Re: Oracle JDBC error

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 26 Jul 2007 08:09:14 GMT
Message-ID: <1185437352.579475@proxy.dienste.wien.at>

Peter Ashford <peter.m.ashford_at_gmail.com> wrote:
> I'm getting this error doing an SQL insert:
>
> java.sql.SQLException: ORA-01745: invalid host/bind variable name
>
> I know there's no invalid names in the insert because I can insert
> data into the table by hand over sqlplus.
>
> I'm using oracle's ojbdc14 jdbc driver and Java 1.6.
>
> Any ideas?

You probably have invalid host variable names.

Check your code! This has nothing to do with INSERTS via sqlplus.

If you are clueless, post a section of your code so people can help you spot what's wrong.
Tell the table definition too!

Yours,
Laurenz Albe Received on Thu Jul 26 2007 - 03:09:14 CDT