Re: pl/sql and hochkommas

On Mon, 8 Dec 2003 22:26:08 +0100, "Hubert Holler" <haiflosse_at_gmx.net> wrote:

>
>"Mark C. Stock" <mcstockX_at_Xenquery .com> schrieb im Newsbeitrag
>news:fMidnXRtF6Uv-kmiRVn-jg_at_comcast.com...
>>
>> "Hubert Holler" <haiflosse_at_gmx.net> wrote in message
>> news:3fd422d4$0$19008$91cee783_at_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
>> |
>> |
>> |
>>
>> what do you mean by 'it doesn't work'? are you getting an error message?
>or
>> are you not getting the rows returned that you expect? as i mentioned in
>my
>> other post, your expression "buchstabe = CHR(39) || upper(buchstabe) ||
>> CHR(39)" will never evaluate to true -- is that the problem?
>>
>yes. What should I do now that it works.
>I will not get an error message.
>
>Hubert
>

For once: Take the original statement and replace the single quotes by chr(39) where appropiate. Is this clear enough or do you need to have it spelled out?

--
Sybrand Bakker, Senior Oracle DBA