By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,483 Members | 3,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,483 IT Pros & Developers. It's quick & easy.

C# Executable File Name Length Causing ODBC Exception

P: 5
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.
Oct 2 '08 #1
Share this Question
Share on Google+
6 Replies


Plater
Expert 5K+
P: 7,872
You mean the length of the name of your program determines if you can connect to oracle or not?
Oct 2 '08 #2

P: 5
Yes .. I know that sounds very wierd...But thats what has been observed
Oct 2 '08 #3

P: 5
I beleive it is on the Oracle side, since the same code has no problems in connecting to a different oracle server
Oct 2 '08 #4

Plater
Expert 5K+
P: 7,872
Perhaps different versions of oracle are running? Or on a different operating system?
Oct 2 '08 #5

P: 5
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
Oct 2 '08 #6

Plater
Expert 5K+
P: 7,872
Perhaps they restructed some directories on that server causing the full path+filename string length to be outside of oracle capabilities?
Oct 2 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.