ODBC, 8i, and Backslashes

I'm hoping someone can help me confirm this as a problem and possibly suggest a workaround? I'm using Oracle 8i (8.1.6) with the 8.1.6.0.0 Oracle ODBC driver.

Creating a simple PL/SQL procedure:

create or replace procedure BACKSLASH_TEST(str in VARCHAR2) is begin
 null;
end BACKSLASH_TEST;

And then calling it with a string containing a backslash from some PL/SQL window, for example:

CALL BACKSLASH_TEST('SOME\STRING'); yields a successful call with no results, of course. But when I call the procedure from ODBC:

{CALL BACKSLASH_TEST('SOME\STRING')} I get the error:

[Oracle][ODBC]Syntax error or access violation.

Removing the backslash from the string and replacing it with, for instance, a space will cause successful execution.

I did try both single a double quote delimeters (as per some inconsistent documentation) around the literal, no difference was found.

I have tried the same with a trial version of the Merant ODBC driver for Oracle and it does NOT exhibit the same problem behaviour with literals containing a backslash.

Can anyone help me get a backslash into a PL/SQL stored procedure via Oracle's ODBC driver?

Thanks!
DK. Received on Sat Jul 08 2000 - 00:00:00 CDT