Hi all,
This is probably obvious but what is wrong with this stored
procedure? I
get the error invalid character ":" Can I not do this?

begin
if (:suptype is null) then
begin
:suptype = 'type';
end

insert into SUPPLIERS
(IDSUP,SUPCODE,SUPNAME,SUPTYPE )
values
(:IDSUP,:SUPCODE, :SUPNAME, :SUPTYPE );

suspend;

end
Thanks
Daniel