Help : End of TNS data channel
can anyone suggest a solution for the error i am getting with a very simple
insert statement ? I am not using anyting advanced like CLOB / BLOB. I am
using Oracle 8.1.5.
java.sql.SQLException: Io exception: End of TNS data channel
thanks in advance.
Re: Help : End of TNS data channel
Check the width of each column ( you are using in Insert statement w.r.t
values (i.e variables) width). Are u using diff. database environment (Database
check and try once again
"news.devx.com" <email@example.com> wrote:
>can anyone suggest a solution for the error i am getting with a very simple
>insert statement ? I am not using anyting advanced like CLOB / BLOB. I am
>using Oracle 8.1.5.
>java.sql.SQLException: Io exception: End of TNS data channel
>thanks in advance.
I got the Oracle error message 'End of TNS data channel' when trying to query over a database link. The problem turned out to be that the link was created using the 'connect to current_user' clause, which implies that the user must be a global user defined in LDAP, which wasn't the case.
Recreating the link without the current_user clause (instead using the default of connected user) solved the problem.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center