[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