Re: little question

"Juan Miranda" <jmiranda_at_mundo-r.net> wrote in message news:94mrot$8e82_at_cesio.mundo-r.com...
> I need to insert the following expresion:
> to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),'990')
> into a varchar2 field.
>
> The problem is the '
> I tried with ' , ' ', ". no way.
>
> How can i proceed ?
>
> Thanks
>
>
> SQL> update m_txt_token set nome_campo=
> 'to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),'990')' where
> nome_campo like 'house';
>

have you tried replacing the embedded single quotes with two single quotes:

update m_txt_token
set nome_campo=
'to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),''990'')' where nome_campo like 'house';

the two single quotes will be evaluated as a single quote within the string constant, which looks suspiciously like an expression to be evaluated. if you're not wanting to store a constant string, then remove the quotes from around the expression:

update m_txt_token
set nome_campo=
to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),''990'') where nome_campo like 'house';

HTH Received on Wed Jan 24 2001 - 23:43:15 CST