Re: Forms 5.0 where clause

From: Rick <Rick.UK_at_nospam.btinternet.com>
Date: Wed, 10 Feb 1999 14:36:26 -0800
Message-ID: <36C209EA.1EA5_at_nospam.btinternet.com>


Gemesi Ferenc wrote:
>
> Dear Gurus!
> 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
My guess is that your crnev column is a CHAR and not a VARCHAR2 column

Rick Received on Wed Feb 10 1999 - 23:36:26 CET

Original text of this message