🚀 go-pugleaf

Leif Suonvieri <leif.s@removethis.hem.utfors.se> wrote:
>pcerdaz wrote:
>> Hy all, I'm working on a SQL from C++Builder BDS2006 with next
>> syntax problem: the IDE use ":" before the name of parameter
>> but Oracle does not accept this character. The Oracle
>> accept "&" character but IDE don't understand it.
>> How can I solve this problem?
>> Thanks in advance.
>
>I don't think I understand your problem.
>The colon in Borland will only be used locally to substitute the named 
>parameter for its value, before it is sent to Oracle, so Oracle won't 
>see it at all.
>/Leif

Thank you and sorry if I'm wrong, but I supose that my problem
is the colon v/s "&" in Oracle. When I try to activate the
following query an exception error is shown: "Operation not
applicable", but if I change the ":Nombre" parameter by a
value the query works well.

SELECT ID, PREFIX, STREET_NAME, SUFIX, CITY, INIIZQ
FROM VIAL_STGO Vial_stgo
WHERE   (STREET_NAME LIKE :Nombre)
   AND  (SUFIX = 'LAS CONDES')
   AND  (PREFIX = 'CALLE')
ORDER BY INIIZQ

Moreover, when I test this query over Oracle it works well
(but using "&" to declare the parameter).

Regards,
PCSdeZ