Subject How to find from system tables if SP parameters has a DEFAULT NULL or not
Author venussoftop
Hi all

I have a SP which has the following parameters
CREATE PROCEDURE RECEIPTNARRATIONACCOUNTS (
TITRID ID,
TISRFID ID,
TCPROMPT Varchar(4096) DEFAULT NULL,
TCSEP Varchar(250) DEFAULT NULL )
RETURNS (....

I can find out the parameters (for all SPs) using the following query
SELECT *
FROM rdb$procedure_parameters
ORDER BY rdb$parameter_number

But somehow I cannot distinguish between the first 2 parameters and the next 2 parameters in terms of DEFAULT NULL.

If there any other system table that might give distinguish this for me. Hope I was able to explain my needs.

Thanks and regards
Bhavbhuti