Re: pl/sql and hochkommas

From: Hubert Holler <haiflosse_at_gmx.net>
Date: Mon, 8 Dec 2003 08:16:12 +0100
Message-ID: <3fd422d4$0$19008$91cee783@newsreader02.highway.telekom.at>

> >
> > I'm not 100% sure I understand what you are asking.
> > You might want to use the CHR() function in place of single or double
> > quote marks.
> >

When I try:
select count(*) into v_vorhanden from wort_suche where wort_id = v_id_wort and buchstabe = CHR(39) || upper(buchstabe) || CHR(39) and benutzer_id = login.getid_benutzer;

it doesn't work but when I try:

select count(*) into v_vorhanden from wort_suche where wort_id = v_id_wort and buchstabe = 'J' and benutzer_id = login.getid_benutzer;

it does work.

I hope someone can tell me the correct syntax for it.

Thank a lot

Hubert Received on Mon Dec 08 2003 - 01:16:12 CST