🚀 go-pugleaf

I am using Delphi 7 on Windows 2000, connecting to DB2 v8.0 running on
a Linux backend.

Whenever I try to activate ANY TSQLStoredProc that requires parameters
I receive an EListError 'List Index out of bounds (0)'. Regardless of
how many parameters there are (as long as there's at least one) and
their type (i, o, i/o) this same thing happens. I've noticed that
there are other people who have posted messages so far using other
databases that produced the same problem, with no luck as to a
solution. Also, I attempted to run a TSQLStoredProc that required
Params on SQL Server 7.0 running on Windows 2000 Server backend and it
produced the same result.

I have traced into the dbExpress source and found the following
problem:

The following procedure call I believe is supposed to populate the
Params from their persistent state set in the environment.

FILE: SqlExpr.pas in Delphi7\source\vcl
LINE:4011.. SetProcedureParams(Self.FSQLConnection, FSQLCommand,
Params, ProcParams)

This calls SetProcedureParams obviously which contains as follows

FILE: SqlExpr.pas in Delphi7\source\vcl
LINE:1053.. ArgDesc := (PSPParamDesc(ProcParams.Items[I]))^

The ProcParams list is empty!!!! Thus producing an invalid index
error.

Any solutions would be greatly appreciated, I am going to forward this
to Borland as well and see what they come up with.