C# Executable File Name Length Causing ODBC Exception

[jaikris317]

I have a C# project that connects to an Oracle server using ODBC

Everything works fine if I keep the file name length less than 23 characters (including ".exe")

If the executable file name exceeds 23 characters this I get the following oracle exceptions

ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 24

This behaviour is observed only for a particular oracle database server .

I have tried changing the connection string and other such options but nothing works.

[Plater]

You mean the length of the name of your program determines if you can connect to oracle or not?

[jaikris317]

Yes .. I know that sounds very wierd...But thats what has been observed

[jaikris317]

I beleive it is on the Oracle side, since the same code has no problems in connecting to a different oracle server

[Plater]

Perhaps different versions of oracle are running? Or on a different operating system?

[jaikris317]

The app was running for a long time on that server .and suddenly stopped running because of this error.

I am thinkin an update patch or an antivirus patch on the server may have caused this error

[Plater]

Perhaps they restructed some directories on that server causing the full path+filename string length to be outside of oracle capabilities?