At 02:03 PM 25/09/2007, you wrote:

>I write:
>
>when gdscode no_dup do
>
> begin
>
> EXECUTE PROCEDURE ATOM_IU(null, null, gdscode);
>
> End
>
>
>
>Ibexpert show error: Feature not supported.
>
>What diffents between sqlcode and gdscode, I need use gdscode

The sqlcode is a higher level grouping of gds error codes. You
should avoid naming objects with reserved words. Assuming you want
the 9-digit alphanumeric code for the GDS exception, rather than the
symbol, you could try this:

create ...
as
declare gdcode char(9);

begin
...
when gdscode no_dup do

begin
gdcode = '335544349';

EXECUTE PROCEDURE ATOM_IU(null, null, gdcode);

End
end

./heLen