Hello Gediminas, Thomas, and all.

>> Is it possible to use domains as SP param type? cause i got error
>> while trying to compile (using rc7):
>>
>> create procedure Test( TextString CHAR24 ....)....
>>
>> CREATE DOMAIN CHAR24 AS
>> VARCHAR(24) CHARACTER SET UNICODE_FSS
>> DEFAULT ''
>> NOT NULL
>> COLLATE UNICODE_FSS

> You can't use domains neither as data types for parameters nor
> for variables.

And what's more: you can't create domains at all in an SP, because
only DML (data manipulation) is allowed, not DDL (Data Definition,
or metadata manipulation).

Except when you use FB 1.5, which has "EXECUTE STATEMENT". With
this, you can get DDL into your SPs "through the backdoor". And then
you can also use parameters to build the statement-to-be-executed.


Greetings,
Paul Vinkenoog