Subject | How to find from system tables if SP parameters has a DEFAULT NULL or not |
---|---|
Author | venussoftop |
Post date | 2011-08-27T07:24:59Z |
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
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