Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: pl/sql and hochkommas
"Hubert Holler" wrote...
>
> 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
Hi Hubert,
do you use a plain select statement or a execute immediate call? In the first case you don't need the single quotes. They will be applied by the engine (well, sort of).
hth,
Guido
Received on Mon Dec 08 2003 - 06:23:52 CST