Hello:

>then your SQL statement will be like
> SELECT BLAH, .......
> FROM MYPROC(99, 'Cabbages')
>or, if using replaceable parameters:
>
> SELECT BLAH, .......
> FROM MYPROC(?, ?)
>
>Use the Firebird ADO .NET provider, though, and ask on the
>firebird-net-provider list about any difficulties, etc.
>

If he is using the Firebird .NET provider he can execute the call
of the sp using only the sp name (if he's using parametrized queries):

A little sample from the Firebird .NET Provider nunit test suite:

...

FbCommand command = new FbCommand("GETVARCHARFIELD", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.VarChar).Value = 1;

FbDataReader r = command.ExecuteReader();

while (r.Read())
{
....
}

r.Close();
command.Dispose();


....


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"In the end there can be only one" (Highlander)