maximum stored proc name in firebird

Posted by Crudler on Stack Overflow See other posts from Stack Overflow or by Crudler
Published on 2010-04-07T09:38:02Z Indexed on 2010/04/26 11:43 UTC
Read the original article Hit count: 414

Filed under:

firebird2.1

|

firebird

Hi,

I am migrating my db from Interbase to Firebird, and the 1st hiccup we hit comes from our stored proc names.

We have a handful of stored procedures with names greater than 31 characters (which appears to be the max in FB 2.1.3)

Is there a way to increase this limitation? It will be a far easier solution than modifying our software.

Thanks!

© Stack Overflow or respective owner

Related posts about firebird2.1

Firebird query is crashing with org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544364. reque

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using JdbcTemplate.queryForInt to insert a Row into the DB, and then get the ID back. The Query is "INSERT INTO metadocs(NAME) values (?) RETURNING METADOCID". If I run the statement in Flamerobin, it works fine. However, if I run it from Java, I get the following error: org.springframework… >>> More
Delphi: how to create Firebird database programmatically

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using D2K9, Zeos 7Alpha, and Firebird 2.1 I had this working before I added the autoinc field. Although I'm not sure I was doing it 100% correctly. I don' know what order to do the SQL code, with the triggers, Generators, etc.. I've tried several combinations, I'm guessing I'm doing something… >>> More
Delphi firebird autocomplete

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I make an autocomplete field in firebird with Zeos. -Brad >>> More
Delphi firebird autoinc

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I make an autoinc field in firebird with Zeos. -Brad >>> More
maximum stored proc name in firebird

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am migrating my db from Interbase to Firebird, and the 1st hiccup we hit comes from our stored proc names. We have a handful of stored procedures with names greater than 31 characters (which appears to be the max in FB 2.1.3) Is there a way to increase this limitation? It will be a far easier… >>> More

Related posts about firebird

How to migrate data from a Firebird database to PostGreSQL on Linux

as seen on Server Fault - Search for 'Server Fault'
Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly written to export/import from one firebird db to another, not as a migration tool. There's also: Firebird… >>> More
Firebird .NET: Database backup not working (small file)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to backup my Firebird 2.5 database file by code: FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = MyConnectionManager.buildConnectionString(); backupSvc.BackupFiles.Add(new FbBackupFile(backupPathFilenameAndExtension, 2048)); backupSvc.Verbose = true; backupSvc.Options… >>> More
Need to compare blobs in firebird

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time). In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating… >>> More
Does firebird support transactional schema changes?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does firebird support transactional schema changes? It seems to me that MySQL does not (am I correct?). >>> More
Firebird sequence-backed ID shorthand

as seen on Stack Overflow - Search for 'Stack Overflow'
What do others do to simplify the creation of simple, serial surrogate keys populated by a SEQUENCE (a.k.a. GENERATOR) in Firebird = 2.1? I finc the process comparatively arduous: For example, in PostgreSQL, I simply type: pg> CREATE TABLE tbl ( > id SERIAL NOT NULL PRIMARY KEY, >… >>> More