SP Problem when using longer names then 22 characters

evdkraan · Post by **evdkraan** » Mon 19 Dec 2011 23:53

Using InterBase 2007 and an UTF8 database with Delphi XE and IBDAC version 3.60.0.24.

First problem is selecting a stored procedure longer then 22 characters in any IBDAC component. All stored procedure names are truncated at 22 characters.

When entering the complete name in the StoredProcName property itself the TIBCStoredProc component accepts it, but it will truncate the parameter names at 22 characters.

When defining the SQL (including the complete parameter names) in the TIBCStoredProc myself the TIBCStoredProc will accept it and generates the correct parameter names.

When executing this TIBCStoredProc it comes back with the following error message:
message length error (encountered 0, expected 8 )

The stored procedure works if the SP name and parameters names stay within the 22 characters restriction.

Both IBX and DBX don’t have this restriction, so it must be somewhere in IBDAC. I know FireBird has a 31 character length restriction, but InterBase doesn't.

AndreyZ · Post by **AndreyZ** » Tue 20 Dec 2011 13:25

Hello,

Thank you for the information. We have reproduced this problem. We will fix this problem in one of the nearest IBDAC builds.

evdkraan · Post by **evdkraan** » Wed 21 Dec 2011 09:29

Thanks for the quick response, as always.

Because I always design my SP's with at least one result, I can work around it by using a TIBCQuery.

Happy holidays

AndreyZ · Post by **AndreyZ** » Fri 02 Mar 2012 14:44

This problem is fixed in the latest IBDAC version 4.1.5 .