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>



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

Original text of this message