Skip to Content
0
Former Member
Oct 29, 2010 at 01:02 PM

Error while executing SP

41 Views

Hi All,

I am gettin an error The data types ntext and ntext are incompatible in the equal to operator whil eexecuting the following SP;

if @object_type = '191' and @transaction_type in ('A','U') 
BEGIN 
if exists
 (Select oscl.callid from oscl
  where oscl.U_SERIALNUM=
  (select p.U_SERIALNUM from oscl p
   where p.callid=@list_of_cols_val_tab_del)
  and oscl.callid!=@list_of_cols_val_tab_del)
begin
set @error =2
set @error_message = 'Duplicate Serial Number !' 
end
END

Thanks,

Joseph