Error Code 206 - Column unknown RDB$PROCEDURE_TYPE on accessing zStoredProc

[FrankBKK]

I tried to play around with ZEOS 7.2.8 and Lazarus 2.0.12 on Firebird 1.56

zConnection, zQuery, zTable etc. all work fine.

However when using zStoredProc and set Active to True I get Error Code 206 - Column unknown RDB$PROCEDURE_TYPE - see below details.

I can access the Params and StoredProcName properties in the ObjectInspector though.
On zConnection I tried protocols firebird, firebird-1.5 and firebirdd-1.5

Just in case I made a backup/restore and also re-created the fdb from scratch to make sure db corruption is not an issue.


Any advice please what to do ?



Error Code 206 - Column unknown RDB$PROCEDURE_TYPE

SELECT RDB$PROCEDURE_TYPE FROM RDB$PROCEDURES WHERE RDBPROCEDURE_NAME = P_INSERT_SAMPLE

[marsupilami]

Hello Frank,

Any advice please what to do ?

The simple advice is to use a more modern Firebird. Please try Firebird 3.0, if possible. This error happens because we try to get some information about the stored procedure and RDB$PROCEDURE_TYPE is a column that was added in later Firebird versions.

If you really need to use Firebird 1.5, please use on of the current SVN versions for Zeos 7.2 or Zeos 8.0. I fixed the problem there. It will be part of the next release.

Best regards,

Jan

[FrankBKK]

Hi Jan,

thanks for your prompt reply !

Yeah, I thought it was something like that.

Your explanation makes perfect sense and to use FB3 would be the right thing to do.

Damn those legacy projects one has to drag along