OCI Question

From: Srinivas Tammana <tsrini_at_yahoo.com>
Date: Mon, 12 Jul 1999 07:49:41 GMT
Message-ID: <3789A04A.7309F37_at_yahoo.com>

Hi, I'm writing an application using
OCI 7.3(against an Oracle8 database).
The problem I'm running into is the
following. If the where clause in the
SQL statement contains an integer(like

select * from acctmast where acctno=10233),

I'm able to get the results back(from fetch). But if it contains a string(like  

select * from acctmast where name='scott'),

fetch is failing(error code 1403) though there is data in the table. Can someone give
pointers as to what might be going wrong( I'm passing the right parameters to obndrv). Any help in this regard is greatly appreciated. You can also reply to tsrini_at_yahoo.com.

Thanks,
--srinivas Received on Mon Jul 12 1999 - 09:49:41 CEST