InterBase error: Name longer than database column size

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

Exchange Links

About this site

Links to us

InterBase error: Name longer than database column size

4 comments. Current rating: 3 stars

(2 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.

Send a message to
Subject

Comments:

2007-10-08, 17:37:06

anonymous from United States

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'

2008-08-27, 08:53:39

anonymous from Brazil

This post help me too much! Thanks!

2009-02-06, 06:12:55

shailesh@armaninfotech.com from India

I have just written a stored procedure in Firebird databaase and it is around 63289 lines and still incomplete. When I am trying to write any more line it is giving the following error:

SQL Error: Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 1, column 1. Error Code: -104. Invalid token The SQL

Is there any limitations regarding the size of stored procedure.
Please reply me in my email id.

Thanks
Shailesh

2009-08-04, 05:07:48

anonymous from India

NEW: Optional: Register Login 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, or post under a registered account.

	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
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. Add a picture:


	Search: