Hi All,

I need to know all stored procedure variable names from a (2.5)
database. I not see these in system tables like parameters or fields.
But I see these with a text editor. For example...

Create a new database and a procedure in it:

CREATE PROCEDURE MY_PROC AS DECLARE VARIABLE MY_VAR INTEGER; BEGIN END

Set RDB$PROCEDURES.RDB$PROCEDURE_SOURCE to NULL.

Backup the database with gbak. I see MY_VAR text in the resulting backup
file (and in the restored database) with a text editor.

So, where is the variable names stored and how to query these?

Gabor