Migration-Problem: Forms4.5 to Forms6.0

From: Thorsten <ludwig_at_mathematik.uni-ulm.de>
Date: 2000/07/10
Message-ID: <396985C6.9C249D19_at_mathematik.uni-ulm.de>#1/1

Hello,

[Quoted] I want to convert an Forms4.5-Application to Forms6.0. In one Funktion I got an error message: "Error 327 ..., 'KLA' is not in SQL scope here" [Quoted] (where 'KLA' is a table...).
The code is

FUNCTION CountTaxOrd (lordnu varchar2, lunord varchar2,

    lfagru varchar2, lklaid number) RETURN number IS   cnt number;
BEGIN
  begin
    select count(*) into cnt from ord, taxon

       where ordnu=lordnu
       and (nvl(unord, lunord) is null or unord=lunord)
       and (nvl(fagru, lfagru) is null or fagru=lfagru)
       and kla.id=taxon.id and taxon.stufe='O'
       and taxon.vorgid=lklaid and taxon.vstufe='K'
        ;

  exception
    when others then null;
  end;
  return cnt;
exception
  when others then return 0;
END; Can anyone help, please?

Thanks and greetings,
Thorsten. Received on Mon Jul 10 2000 - 00:00:00 CEST