Calling Stored-Procedures having string-arguments with ODBC

From: Thomas Marzinka <tmarzinka_at_init-ka.de>
Date: 2000/05/31
Message-ID: <3934FEA0.6525873F@init-ka.de>#1/1

Hello everybody there outside,

I want to call stored procedures with string arguments containing backslashes over ODBC. There has been no problem doing this until ODBC driver and Client version 8.04.

But in the later Versions Oracle changed the implementation. If i call stored procedures using "{ call <procedure_name>('a\a')} an error occurs. Do the same thing with an anonymous PL/SQL-block the Statement works.

Do anybody know why Oracle changed the behavior ? The hotline couldn't tell me the reason. Is it sure that with an anonymous PL/SQL-block also in future times calls with backslashes will be possible? What the hell is the sense of this modification?

thomas Received on Wed May 31 2000 - 00:00:00 CDT