ODBC drivers

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Tue, 5 Sep 2000 09:58:18 -0300
Message-Id: <10610.116203@fatcity.com>

Hi

I have strange behavior of ODBC drivers and wonder if anyone else noticed it, knows fix for it. Here it goes:

I have a stored procedure that takes three parameters VARCHAR2, VARCHAR2, NUMBER
the call through ODBC would be, for example,:

begin my_proc('-1', 'INT_TEN_RS', 1); end;

I connect to Oracle 8.1.6 database on Sun Solaris from Windows NT 4.0 SP 5. When I use Microsoft ODBC driver or old Oracle ODBC driver (Oracle 73 ver 2.5) it works. But when I use Oracle ODBC driver installed with Oracle 8i client (ver 8.01.06.00) sometimes it works but in most cases it returns error 6550 with the message:
line1, column 64: PLS-00103: Encountered the symbol "" The symbol "" was ignored.

I would look into the procedure but it works with other drivers, as well as with OCI etc.

Has anyone worked with the driver?

Thanks

Witold

---

Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com Received on Tue Sep 05 2000 - 07:58:18 CDT