[DB-SIG] Parameters in DCOracle2
Marcos Sánchez Provencio
msanchez@grupoburke.com
Fri, 16 Aug 2002 14:45:45 +0200 (CEST)
Hello, I am having a problem trying to get some data from an Solaris Oracle
7.3.3 server. I use the 8.1.7 client in the same machine. The problem is as
follows:
I get results if I say
where nombre='SAENS'
but not if I say
where nombre=:p1
and pass a parameter 'SAENS', fetchall returns an empty list
It is funny that I get some results if I say
where nombre between :p1 and :p1 || 'Z'
or (almost) what I want by saying
where nombre like :p1 || ' %'
I have been puzzled by Oracle since I am using it (I had used Sybase before).
Is this an Oracle issue or a Python one?
Thank you very much