Incompatilbe column/host variable data type

[ZOD]

@nahpets

Zur einfacheren Diskussion ein konretes Beispiel. Ich verwende

Code:

    select
    lt.id,
    lt.date_time,
    lt.operation,
    lt.user_name
    from ibe$log_tables lt
    where
    (
      (:tmp_tabellen_name = cast('*' as varchar(201)))
      or
      ((not (:tabellen_name = cast('*' as varchar(201)))) and (lt.table_name = f_lrtrim8(f_upper(:tmp_tabellen_name))))
    )
    and
    (
      (:tmp_db_operation = cast('*' as varchar(1)))
      or
      ((not (:tmp_db_operation = cast('*' as varchar(1)))) and (lt.operation = f_lrtrim8(f_upper(:tmp_db_operation))))
    )
    order by
    lt.date_time desc
    rows 1

Und das funktioniert wie gewünscht.