Forms 5.0 where clause
From: Gemesi Ferenc <gferi_at_econet.hu>
Date: Wed, 10 Feb 1999 14:22:08 +0100
Message-ID: <36C187FF.C3050FB3_at_econet.hu>
What is the problem with this 'KEY-NEXT-ITEM' PL/SQL script in 'Forms 5.0' (Windows 95 Client), ORACLE 8 (Linux server)?
Date: Wed, 10 Feb 1999 14:22:08 +0100
Message-ID: <36C187FF.C3050FB3_at_econet.hu>
Dear Gurus! [Quoted]
What is the problem with this 'KEY-NEXT-ITEM' PL/SQL script in 'Forms 5.0' (Windows 95 Client), ORACLE 8 (Linux server)?
declare
varstring varchar2(40);
begin
varstring := 'DEMASZ';
select ckod into :VALARF.CKOD from ceg where crnev
= varstring;
/* select ckod into :VALARF.CKOD from ceg where crnev = 'DEMASZ';*/
end;
This not working (FRM-40735: KEY-NEXT-ITEM trigger raised unhandled
exception ORA-01403)
But with the second 'select clause', it is working!
Thank You for help
gferi
gferi_at_econet.hu
Received on Wed Feb 10 1999 - 14:22:08 CET