WHERE mach_id = :id;
if (cnt > 0)
return(MR_IN_USE);
+ EXEC SQL SELECT COUNT(mach_id) INTO :cnt FROM hostalias
+ WHERE mach_id = :id;
+ if (cnt > 0)
+ return(MR_IN_USE);
EXEC SQL DELETE FROM mcmap WHERE mach_id = :id;
if (dbms_errno) return(mr_errcode);