DelphiFAQ Home Search:
Databases
    InterBase (28)
    MS-SQL (5)
    mysql (32)
    Oracle (1)

 
Exchange Links
 
About this site

Links to us

Tell a friend
Friend's name
Friend's email
My name
My email
Short note
 
Bookmark this
Add to del.icio.us Digg! Add to Reddit Add to Yahoo MyWeb Add to Windows Live Add to Google Bookmarks Share via Facebook

InterBase error: Name longer than database column size

 

comments1 comments. Current rating: 4 stars (1 votes). Leave comments and/ or rate it.

Question:

I just wrote a long stored procedure with many arguments and get the error message "Name longer than database column size". Do I actually have to reduce the number of arguments by nesting stored procedure calls?

Answer:

The error message refers to the name of your stored procedure, not to the number of arguments. In Interbase 5.5 through 6.5 the length of a column name, a table name or stored procedure and probably all other metadata objects is limited to 31 characters.

You cannot work around this limitation, other than renaming your stored procedure.


Comments:

2007-10-08, 17:37:06
anonymous from United States  
rating
I'm getting the same error on a brand new Firebird 2.03 database.

While 31 chars might be long enough for individual columns, it is NOT ENOUGH to name foreign keys, etc. because they might have the names of 2 columns, like:

'FK_LONGCOLUMNNAME_LONGTABLENAMELONGCOLUMNNAME'

 

 

Email address (not necessary):

Rate as 		Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option.
 
It seems that you are
from Washington, US .

Info/ Feedback on this

Show city and country
Show country only
Hide my location
Leave your comment here:
Please type in the code:
photo Add a picture:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.