Commented by: Sean Leyne (seanleyne)

Alexander,

You seem to be logging a large number of feature requests which have already been discussed and rejected (in the support list) or are not always appropriate (as in this case).

I would suggest that you post a discussion message to the developer list before creating these entries. In this way, the requests can be publically discussed, and perhaps improved upon, before an entry is added to the tracker.

Commented by: Alexander Tyutik (tut)

Sorry.

I started read developers list only a few months ago, so i haven't read discussion about this feature.
And, from other side, in some fb newsgroups i saw such dialogs:
User: Why this feature was not implemented?
Developer: I don't see any feature request in tracker about this feature, so why it should be implemented?

In feature i will be more careful with requests like this...

Commented by: Claudio Valderrama C. (robocop)

The feature has been implemented by Adriano. This is the result of an isql session:

SQL> create database 'mydearnull.fdb';
SQL> create procedure get_something(id integer not null) as begin end;
SQL> execute procedure get_something(NULL);
Statement failed, SQLCODE = -625
validation error for variable ID, value "*** null ***"
-At procedure 'GET_SOMETHING'
SQL> execute procedure get_something(1);

SQL> set term ^;
SQL> create procedure p0(inp int) as declare i int not null; begin i = inp; end^
SQL> set term ;^
SQL> execute procedure p0(null);
Statement failed, SQLCODE = -625
validation error for variable I, value "*** null ***"
-At procedure 'P0' line: 1, col: 63
SQL> execute procedure p0(1);

The only improvement could be that in the first case, the message can say "validation error for parameter ID, ..." instead of "variable".

Commented by: @pmakowski

Q/A test ok