Re: Forms 5.0 where clause

Thank You, the answer
This was the solution...
gferi

Rick wrote:

> 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 Mon Feb 15 1999 - 16:08:28 CET